Rasmus,
you are dead right, it is returning 0 rows. I checked that before
submiytting the original post. Sorry, i should have mentioned it. I guess
the question is, why is it returning no rows?
> From: Rasmus Lerdorf <[EMAIL PROTECTED]>
> Date: Mon, 16 Jul 2001 19:56:29 -0700 (PDT)
> To: Brad Wright <[EMAIL PROTECTED]>
> Cc: PHP General List <[EMAIL PROTECTED]>
> Subject: Re: [PHP] Whats wrong with this code?
>
>> Hi all, Im getting mighty frustrated with this peice of code. It checks the
>> first condition no probs, but the second IF statement doesnt work. So it
>> will stop if it finds a du[plicate login, but cannot find duplicate
>> passwords. the $num_rows2 variable always gets the value '0' even when there
>> is an existing password the same as the new user-entered value.
>
>> $result = mysql_query("SELECT * FROM Login_TB where Login='$Login'",$db) or
>> die ("ouch");
>>
>> $num_rows = mysql_num_rows($result);
>
>> $query2 = "select * FROM Team_Login_TB where Pass = password('$Pass')";
>> $result2 = mysql_query($query2,$db) or die ("ouch2");
>> $num_rows2 = mysql_num_rows($result2);
>
> Your second query must not be returning any rows. Print out $query2 and
> paste the string you see into the command line mysql tool and execute the
> query. I bet it will return 0 rows.
>
> -Rasmus
>
>
>
> --
> PHP General 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]
>
--
PHP General 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]
