thanks. i have resolved the problem by replacing 'read' with 'read_it'. On 12/30/05, Michael Gross <lists@xxxxxxxxxxxx> wrote: > "read" is a reserved word in mysql > (http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html). You have > to double-quote reserved words: > > mysql_query("SELECT * FROM mailbox WHERE \"read\"=''"); > > Graham Cossey wrote: > > On 12/29/05, Jay Blanchard <jay.blanchard@xxxxxxxxxxx> wrote: > >> [snip] > >> could you please tell me what is the problem with this query > >> mysql_query("SELECT * FROM mailbox WHERE read=''"); > >> > >> i always get this warning: > >> Warning: mysql_num_rows(): supplied argument is not a valid MySQL > >> result resource in index.php on line 24 > >> [/snip] > >> > >> THere is no apparent problem with the query, but there is a problem with > >> mysql_num_rows(). Can you show us he code there? > >> > > I would hazard a guess that mysql_num_rows() is not being passed the > > correct query result handle as a parameter. > > > > ie: $result = mysql_query(...); > > $rows = mysql_num_rows($result); > > > > -- > > Graham > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
