check duplicate

[fer0an]

hello

I've a db with some data

I want to check content, if title dosen't exist create it and if exist continue.

My db column is -->id--title--introtext--fulltext--link

anyone can help me?

[SchweppesAle]

Something like this i guess.

 

$title = 'blahblah';

/*leave out the * in yourtablename*/
$query = "SELECT * FROM *yourtablename* WHERE title = '$title'";
$result = mysql_query($query);

if(mysql_num_rows($result) == 0)
{
$query = "INSERT INTO *yourtablename* (id,title,introtext,fulltext,link) VALUES (NULL,Titleblahblah,fulltextblahblah,linkblahblah)";
$result = mysql_query($query);

if(!result)
{
die("problem inserting data: ".mysql_error());
}
}

[fer0an]

Thank you