PROS! Duplicate checking? Help?

[Anon]

Hi,

Ok, I have a MySQL database running on my server. Through a form, items are being submitted into the database.

One of the fields being enterted is TITLE.

Now, is there a way via some PHP code that I can check to see if a TITLE has already been enterted?

Basically, if a TITLE HAS BEEN entered, I want to spit out a duplicate error, letting the user know that the title ALREADY exisits in the DB.

If the TITLE doesn't exist, I want the information to be enterted!

Please help! I think this is easy!

Thanks.

[Anon]

You just do a query and see if it returns anything:

$query = "SELECT * FROM tbl WHERE title='$title'";
$result = mysql_query($query, $con);
if (mysql_num_rows($result) == 0) {
// safe to add
} else {
// error: dup in db.
}

Diego

[Anon]

NICE!!

Thanks. Gonna try this!

Brian