View Single Post
Old Jan 9th, 2006, 4:14 AM   #4
magic_e
Programmer
 
Join Date: Jan 2005
Posts: 44
Rep Power: 0 magic_e is on a distinguished road
you shouldn't really use the @ supresser until you are ready for use in a public environment, it's better to fix the errors than to hide them


try this instead a thinks it's what your after
[PHP]
$sql_email_check = mysql_query("SELECT * FROM users
WHERE email_address = '$email_address'");

$sql_username_check = mysql_query("SELECT * FROM users
WHERE username='$username'");

$email_address = mysql_num_rows($sql_email_check);
$username_check = mysql_num_rows($sql_username_check); [/PHP]
it should return the number of entrys that meet the supplied critera,

cheers

magic e
magic_e is offline   Reply With Quote