DB "already registered user" Help

[Mark]

help, why wont this work?

<? 
$db = mysql_connect("localhost","****","*****"); 
$usercheck = "SELECT count(id) from biohazard_users where username = '$username'";
mysql_select_db ("biohazard_login"); 
if(empty($username) || empty($passwd) || empty($firstname) || empty($lastname) || empty($email))
{
mysql_close($db); 
die();}

$result = mysql_query ("INSERT INTO biohazard_users (username, passwd, firstname, lastname, email, age, homepage, imservicename, aim, yahoo, icq) 
                VALUES ('$username', '$passwd', '$firstname', '$lastname', '$email', '$age', '$homepage', '$imservicename', '$aim', '$yahoo', '$icq')");

//check if username is already taken.

if($usercheck = 0)
{
}
else{
mysql_close($db); 
echo "A User arealy has that name, please try again.";
exit();}

if(!$result) 
{ 
   echo "<b>There was a problem!</b> ", mysql_error(); 
   exit(); 
}
if($result) 
    { 
    mysql_close($db); 
    print "Thank you for registering with Biohazard! you may now login!";
	include("login.php"); 
    } 
?>

[bastien]

you want comparison so double equal signs

if($usercheck == 0)

[Mark]

ok, i'll try that :d

[Mark]

when i try it like this, it doesnt work, it displays the user already registered message to every registration, And still puts the info into the DB.

if($usercheck == 0)
{
}
else{
mysql_close($db); 
echo "A User arealy has that name, please try again.";
exit();} 

[[deleted]]

<? 
$db = mysql_connect("localhost","****","*****"); 
$usercheck = "SELECT count(id) from biohazard_users where username = '$username'";
mysql_select_db ("biohazard_login");

?>

At this point $usercheck is just holding the sql statement "SELECT blah blah blah..."

[Mark]

ok?😕

<? 
$db = mysql_connect("localhost","****","****");

$sql = "SELECT * FROM biohazard_users WHERE username='$username'";
$result2 = mysql_query($sql);

mysql_select_db ("biohazard_login"); 
if(empty($username) || empty($passwd) || empty($firstname) || empty($lastname) || empty($email))
{
mysql_close($db); 
die("
Please fill in the required(<font color=#446bac>*</font>) forms. <a href=\"/?bh=register\">Go Back.</a>
</td>
	<td align=\"center\" valign=\"top\" background=\"rightt.jpg\" width=\"138\">
	<iframe src=\"shout.php\" width=\"130\" height=\"478\" frameborder=\"0\" scrolling=\"no\" style=\"{border-width:1;border-style:inset;border-color: black;}\"></iframe>
	</td>
</tr>
<tr>
<td background=\"bottom.jpg\" width=\"974\" height=\"12\" colspan=\"3\"></td>
</tr>
</table>

</body>
</html>

");}

if($result2 != false){ 
echo "Username taken, Please try again";
mysql_close($db);
exit("

  </td>
	<td align=\"center\" valign=\"top\" background=\"rightt.jpg\" width=\"138\">
	<iframe src=\"shout.php\" width=\"130\" height=\"478\" frameborder=\"0\" scrolling=\"no\" style=\"{border-width:1;border-style:inset;border-color: black;}\"></iframe>
	</td>
	<tr>
<td background=\"bottom.jpg\" width=\"974\" height=\"12\" colspan=\"3\"></td>
</tr>
</tr>
</table>

</body>
</html>

   ");
} 				

$result = mysql_query ("INSERT INTO biohazard_users (username, passwd, firstname, lastname, email, age, homepage, imservicename, aim, yahoo, icq) 
                VALUES ('$username', '$passwd', '$firstname', '$lastname', '$email', '$age', '$homepage', '$imservicename', '$aim', '$yahoo', '$icq')");

if(!$result) 
{ 
   echo "<b>There was a problem!</b> ", mysql_error(); 
   exit("

  </td>
	<td align=\"center\" valign=\"top\" background=\"rightt.jpg\" width=\"138\">
	<iframe src=\"shout.php\" width=\"130\" height=\"478\" frameborder=\"0\" scrolling=\"no\" style=\"{border-width:1;border-style:inset;border-color: black;}\"></iframe>
	</td>
	<tr>
<td background=\"bottom.jpg\" width=\"974\" height=\"12\" colspan=\"3\"></td>
</tr>
</tr>
</table>

</body>
</html>

   "); 
}
if($result) 
    { 
    mysql_close($db); 
    print "Thank you for registering with Biohazard! you may now login!";
	include("login.php"); 
    } 
?>

[[deleted]]

OK?

You need to run the query...

// defines connection
$db_conn = mysql_connect(...);

// defines database to use
$db = mysql_select_db(...);

// defines sql statement
$usercheck = "SELECT * FROM biohazard_users WHERE username = '$username'";

// use * because you'll want to check email too.

// runs query
$check_user = mysql_query($usercheck)

// if username NOT less than 1, different way of saying zero 😉
if (!$check_user < 1)

{

// then username already exists

}