Register Script Help

[CammyD]

I am STILL working on my members area thing and i need some more help!

How do make php insert a new user if they don't already exist?

So if user CammyD already exists, it would give you and error.

Here is my table build up

 

Table 'users':

 

id - AUTO

 

userlevel - always 1

 

username - $username

 

password - $password

 

email - $email

[ratcateme]

here try this

<?php
$query="SELECT `username` FROM `users` WHERE `username` = {$username}";
$result=mysql_query($query);
if(mysql_num_rows($result)==0){
//register user
}else{
//username allready exists
}
?>

 

Scott.

[stanleybb]

Have you set up a direct connection to the database/table?

[Lamez]

well you could do this

 

<?php
$r = mysql_query("SELECT * FROM `users`");
$row = mysql_fetch_array($r);
if ($_POST['username'] !== ($row['username'])){
mysql_query("INSERT INTO `users` VALUES ('$_POST['username']', '$_POST['password']')");
}else{
echo "username exist";
}
?>

 

you might want to add a loop. I am not sure if this code works.

[CammyD]

Thanks guys!