Miscellany

if(isset($_request['show_total_stock']))
	{
// Get all the data from the "tournament" table
$result = mysql_query("SELECT * FROM products") 
or die(mysql_error());  

echo "<table border='1'>";
echo "<tr> <th>Id</th> <th>Name</th> <th>Type</th> <th>Price</th></tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
	// Print out the contents of each row into a table
	echo "<tr><td>"; 
	echo $row['id'];
	echo "</td><td>"; 
	echo $row['name'];
	echo "</td><td>"; 
	echo $row['type'];
	echo "</td><td>"; 
	echo $row['price'];
	echo "</td></tr>"; 
} 
echo "</table>";
}
if(isset($_request['show_all_entries']))
	{
	// Get all the data from the "tournament" table
$result = mysql_query("SELECT * FROM tournament order by tickets desc") 
or die(mysql_error());  

echo "<table border='1'>";
echo "<tr> <th>Name</th> <th>Tickets</th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
	// Print out the contents of each row into a table
	echo "<tr><td>"; 
	echo $row['name'];
	echo "</td><td>"; 
	echo $row['tickets'];
	echo "</td></tr>"; 
} 
echo "</table>";
}
?>