Wonderful MySQL!!!

[fnbcprog]

Is there anyway to check if a query did not return any results without using mysql_num_rows or is that the only way??

[lanjoky]

Never tried this but I belive you can do a mysql_fetch_array and if the result of the fetch is null on the first instance/use of it then there are no records in the recordset.

Just a Thought

HTH

[stolzyboy]

mysql_num_rows is your best bet, what is the reason you don't want to use it, maybe we can give you suggestions on how to do it differently

[mattr]

I would agree that the function num_rows is probably the best way to do it.

Without it, well you can do something like:

$foo = query( "select foo from bar" );

$output_string = '';

while( $row = fetch_array( $foo ) )
   $output_string .= $row[ 'foo' ];

if( !$output_string )
  echo "No output!";