RE: [PHP] mysql_num_rows always returns 1?

2002-06-18 Thread David Freeman
> $query = "select count(*) from users where " You are asking for a count() in your query. This will always give you one row returned with a count. If you really want to do this you should probably have: $query = "select count(*) as usercount from users where" Then you can do your te

Re: [PHP] mysql_num_rows always returns 1?

2002-06-18 Thread Eugene Mah
At 13:00 18-06-02 +0100, Mark Colvin wrote: >The function below works when I pass in a valid username and password and >returns '1'. When I pass a username and password that is not in the database >it still returns '1'. I have put some echo statements in for debugging and >the value of $numresult

RE: [PHP] mysql_num_rows always returns 1?

2002-06-18 Thread Niklas Lampén
Original Message- From: Mark Colvin [mailto:[EMAIL PROTECTED]] Sent: 18. kesäkuuta 2002 15:00 To: [EMAIL PROTECTED] Subject: [PHP] mysql_num_rows always returns 1? The function below works when I pass in a valid username and password and returns '1'. When I pass a username a

[PHP] mysql_num_rows always returns 1?

2002-06-18 Thread Mark Colvin
The function below works when I pass in a valid username and password and returns '1'. When I pass a username and password that is not in the database it still returns '1'. I have put some echo statements in for debugging and the value of $numresult is always '1'. Does mysql_num_rows retain result