[Resolved] Database Query

[asa_carter]

hi,

I'm having another problem with this. For some reason, it is outputting 'Resource id #4' as well as any valid results, even when there are no results to display.

$query = mysql_query("SELECT id, item FROM item WHERE auction_end BETWEEN NOW() AND DATE_ADD(NOW(),INTERVAL 5 MINUTE)",$mysql_access) or die ("SQL error: ".mysql_error());
if ($query)
  while($row = mysql_fetch_row($query))
    $result = $row[1].$result.", ";
else 
  $result = "no results ending soon..";

Thanks,

Asa

[sfullman]

$query = mysql_query("SELECT id, item FROM item WHERE auction_end BETWEEN NOW() AND DATE_ADD(NOW(),INTERVAL 5 MINUTE)",$mysql_access) or die ("SQL error: ".mysql_error()); 
if (mysql_num_rows($query))  // <-- notice my change 
   $result='';  //<-- start with blank!
  while($row = mysql_fetch_row($query)) 
    $result = $row[1].$result.", "; 
else  

  $result = "no results ending soon..";

I thknk what it is is you have something printing from somewhere else. Did you use $result to make a connection prior? suspect you did :-)
Sam

[asa_carter]

Yeh that was it. I was using $result in an include file and i am using javascript to display the results. Thanks.