|
I found out why it was I had some misspelled words in my form but now this is the problem i'm receiving.
[PHP]
$sql_email_check = mysql_query("SELECT email_address FROM users
WHERE email_address='$email_address'");
$sql_username_check = mysql_query("SELECT username FROM users
WHERE username='$username'");
$email_check = mysql_num_rows($sql_email_check);
$username_check = mysql_num_rows($sql_username_check); [/PHP]
if I do this
[PHP]$sql_email_check = mysql_query("SELECT email_address, FROM users
WHERE email_address = '$email_address'");
$sql_username_check = mysql_query("SELECT username, FROM users
WHERE username='$username'");
$email_address = mysql_num_rows($sql_email_check);
$username_check = mysql_num_rows($sql_username_check);[/PHP]
The emails are always matching
And if I do the top I get mysql_num_rows errors?
And the only way I found was doing this
[PHP]$sql_email_check = mysql_query("SELECT email_address, FROM users
WHERE email_address = '$email_address'");
$sql_username_check = mysql_query("SELECT username, FROM users
WHERE username='$username'");
$email_address = @mysql_num_rows($sql_email_check);
$username_check = @mysql_num_rows($sql_username_check);[/PHP]
Would doing number 3 be right or good to do and if not how can I get it to work without using the @ but also where it checks to see they match but not constantly say they are matching?
|