Re: Whats wrong with this code?
| From: | Rasmus Lerdorf | Date: | Tue, 17 Jul 2001 02:56:29 +0000 |
| Subject: | Re: Whats wrong with this code? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-58163@lists.php.net to get a copy of this message | ||
> 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