MySQL Query in PHP - Checking duplicates? : phpMyAnswers

MySQL Query in PHP - Checking duplicates?

demo 23 Dec 2008 08:43am
I have something in my website where you pick a name, but I need it to check if the name isn't taken, so how would I use a MySQL query to check what the user typed in. Something like ...

$namecheck = *MySQL query here*

if($namecheck = 0)
*make account*
else
*give error*

Thats basically how my code is

Answers

demo 23 Dec 2008 08:49am
Assuming the table where you store the name is users, containing a field 'name' where you store the name, and a field 'id' that contained the record id:

SELECT id FROM users WHERE name=$name;

If a record is found, the name was already in use.

demo 23 Dec 2008 09:29am
$namecheck=mysql_query("select * from user where name=$x");
if($namecheck!=NULL)
{
make account
}

How to find the server version of MySQL?
How do you get MySQL working on macbookpro?
Setting up local servers (mysql, mail,...)?
Can anyone tell me what MySQL is?
cpanel download question?

Submit Answer

You must be logged in to post an answer. Please Login or Register.