RE: [PHP] mysql_num_rows
| From: | Joe Kaiping | Date: | Thu, 27 Sep 2001 20:58:31 +0000 |
| Subject: | RE: [PHP] mysql_num_rows | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-69054@lists.php.net to get a copy of this message | ||
Hi Nate,
you probably just need to quote the strings you are looking for:
$result = mysql_query("SELECT * FROM students WHERE
username='$login' AND password='$password'",$db);
Take care,
Joe
> -----Original Message-----
> From: Nate Sanden [mailto:natesanden@hotmail.com]
> Sent: Wednesday, June 21, 2000 1:51 PM
> To: php-general@lists.php.net
> Subject: [PHP] mysql_num_rows
>
>
> can someone tell me what im doing wrong here..
>
> $result = mysql_query("SELECT * FROM students WHERE
> username=$login AND password=$password",$db);
>
> if(mysql_num_rows($result)==0)
> {
> echo "0 results returned."
> }
> else {
>
> echo "1 or more results found.";
> }
>
> When i do a query from phpmyadmin, it finds one field, yet
> returns 0 results when i do it from my own page.
>
> Thanks!
>