RE: [PHP-DB] mysql_num_rows
| From: | Ford, Mike [LSS] | Date: | Tue, 08 Jan 2002 14:07:10 +0000 |
| Subject: | RE: [PHP-DB] mysql_num_rows | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-15528@lists.php.net to get a copy of this message | ||
> -----Original Message-----
> From: Gurhan Ozen [mailto:c-gurhan.ozen@wcom.com]
> 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: m.ford@lmu.ac.uk
Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211