php/sql question: is the following possible to query a mysql database to echo who has the max totalmark?

1 Comment

• Marc

  June 8, 2010 at 10:54 am

  It’s not really necessary to use all of the globals provided as you can make them with your own functions.

  first connect because you can’t query without a connect.
  you also need to select a database.

  < ?php
  $max = 0; set the checking variable

  $con = mysql_connect("host", "user", "pass");
  mysql_select_db("your databse", $con); select your database using the $con connection
  $query = "SELECT * FROM tablename"; get all the info so that you can compare.
  $information = mysql_query($query, $con); get the information

  while ( $results = mysql_fetch_assoc($information) ) this is where the information is retreived
  {

  if ( $results["columnName"] > $max )
  {
  $max = $results["columnName"];
  };

  };

  print $max;
  ?>

  done!

  See you don’t need to remember all the superglobals if you really understand the code!

  UPDATE: FOR THE COLUMN NAME MAKE IT ANYTHING YOU LIKE. I personally would name it totalNumber or max.

  It doesn’t matter as long as you are consistent.