I have an idea about how to solve it. . . contact the PHP list, or whatever the programming language you are using shows.
You might also try printing out the query that the program is using, and run that command from the mysql client directly, to see if the result is an error or if it really returns 0 rows. -Sheeri On 11/24/05, fa so <[EMAIL PROTECTED]> wrote: > > 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 > > 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! Personals > Single? There's someone we'd like you to meet. > Lot's of someone's, actually. Yahoo! Personals > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]