RE: [PHP-DB] mysql_num_rows
| From: | matt stewart | Date: | Tue, 08 Jan 2002 14:09:48 +0000 |
| Subject: | RE: [PHP-DB] mysql_num_rows | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-15529@lists.php.net to get a copy of this message | ||
don't know if this makes a difference, but i've always used WHERE bookid =
'$bookid'"; - single quote round the $bookid variable - not sure if that's
the problem, or if it's just good practice?
-----Original Message-----
From: Ford, Mike [LSS] [mailto:M.Ford@lmu.ac.uk]
Sent: 08 January 2002 14:07
To: 'Gurhan Ozen'; php-db@lists.php.net
Subject: RE: [PHP-DB] mysql_num_rows
> -----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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
For additional commands, e-mail: php-db-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.312 / Virus Database: 173 - Release Date: 31/12/01
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.312 / Virus Database: 173 - Release Date: 31/12/01