Drop the "$result" from the mysql_num_rows() so it reads: $num_results=mysql_num_rows();
Depending upon the PHP version, that might do the trick for you. kind regards, bill Mike Ford wrote: > > -----Original Message----- > > From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] > > Sent: 06 January 2002 20:10 > > > > I am pretty sure that the query is correct. here is the actual query: > > $query="select distinct(nodeid), nodename > > from books where > > bookid=$bookid"; > > $result=mysql_query($query); > > $num_results=mysql_num_rows($result); > > > <snip> > > The funny thing is that if i write the same query without "where > > bookid=$bookid" then the mysql_num_rows works but with where > > statement it > > doesn't. > > Have you echoed $result to see what it contains? My guess is that it contains >something unexpected which, when inserted into the query, causes it to fail (or at >least return no rows!). Otherwise, I can see no reason for the addition of the WHERE >clause to cause this error. > > Cheers! > > Mike > > --------------------------------------------------------------------- > Mike Ford, Electronic Information Services Adviser, > Learning Support Services, Learning & Information Services, > JG125, James Graham Building, Leeds Metropolitan University, > Beckett Park, LEEDS, LS6 3QS, United Kingdom > Email: [EMAIL PROTECTED] > Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
