Dear All I have a problem with mysql_num_rows if I execute it on a result returned by mysql_query,,, and that result is empty then I will get an error saying that this result is not a valid mysql result,,, but i think it should return ZERO! I am using count(*) and checking if my SQL statements will return more than 0 results,, but because i am using InnoDB engine, it is very inefficient to use count(*) very much because it will search the whole table any Idea how to solve this? regards
--------------------------------- Yahoo! FareChase - Search multiple travel sites in one click.