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


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]

Reply via email to