> > -----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 

Sorry, that should be $bookid...!!

> 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]

Reply via email to