PHP & MySQL issue - Results from query but no output

[merc123]

Hey guys had a problem that has me stumped.

 

I've got a MySQL DB with the table called scr_results with the fields date, SLM and LLM.  I just want the date field and to output it so I've tried the following below.

 

It shows I have 2 results but it doesn't display anything and I can't remember an alternative to print_r to see the array of the query.

 

Also, there are no errors.

 

  include_once("../connect.php");  //Connect to DB
  $query= mysql_query("SELECT `date` FROM `scr_results`") or die(mysql_error());
  $result= mysql_numrows($query);  //Return 2 fields
  if ($result == '0') { echo "No results found.  You need to add some first."; echo "<HR><a href=>Back to Administration Console</a><BR>"; exit; }
  if ($result == '1') {
  while ($row=mysql_fetch_array($query))
  {

   echo $row['date'];

  }
}

[merc123]

Nevermind, as soon as I posted it I saw the error.  if ($result == '1')  should be if ($result >= '1')