> 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]
