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 ""; echo ""; // 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 ""; } echo "
Id Name Type Price
"; echo $row['id']; echo ""; echo $row['name']; echo ""; echo $row['type']; echo ""; echo $row['price']; echo "
"; } 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 ""; echo ""; // 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 ""; } echo "
Name Tickets
"; echo $row['name']; echo ""; echo $row['tickets']; echo "
"; } ?>