okay, i am working with mysql now
my problem is this
a user makes an account on my site
i want to check if there is a user using that nickname allready
thencks guys
see if a field allready exists
Moderator: General Moderators
- shiznatix
- DevNet Master
- Posts: 2745
- Joined: Tue Dec 28, 2004 5:57 pm
- Location: Tallinn, Estonia
- Contact:
Code: Select all
$query = '
select
username
from
table_name
where
username = "$username"
';
$do_query = mysql_query($query) or die(mysql_error());
if (mysql_num_rows($do_query))
{
die('username taken');
}
else
{
//create user query
}