[SOLVED] Probably a noob php/mysql query question.

[iPixel]

Ok, to keep a long story short. I have a database with two fields. Date & Info.

I've got mostly everything done now i just need to enter the data into the database via php.

 

Question... what is the syntax to check if a record with a DATE that's passed already exists.

 

I want to INSERT if it doesn't exist and UPDATE if it does.

[Garethp]

if(!mysql_num_rows(mysql_query("SELECT * FROM `table` WHERE `DATE`='$Date'")))
{
mysql_query("DO INSERT HERE");
}

[iPixel]

Heh i suppose that will do, i was thinking of some sort of IF EXISTS like when they do so in table creation. But this will do just fine. TY.