...

View Full Version : mysql gone wrong again



rafiki
08-23-2007, 02:05 PM
this time its num_rows

$sql_email_check = mysql_query("SELECT email FROM users
WHERE email='$email' AND status='Alive'");
$sql_username_check = mysql_query("SELECT username FROM users
WHERE username='$reg_username'");

$email_check = mysql_num_rows($sql_email_check);
$username_check = mysql_num_rows($sql_username_check);

Nightfire
08-23-2007, 02:28 PM
If you added mysql error to the end of the query, you'll know what's wrong.



$sql_username_check = mysql_query("SELECT username FROM users
WHERE username='$reg_username'") or die(mysql_error());



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum