insert if not in DB

[Miko]

Hello,

 

I'm creating a script that should check in my MySQL DB if a value is allready present or not, if it is not present it should insert it into the database.

 

Was thinking of doing like this:

 

SELECT * FROM dates WHERE date = $date AND depot = $depot

 

then add an IF statement

 

if($sql_date != $date){
  "insert into db statement and code
} 

 

Seems that it isn't a correct way to do it?

Maybe work with array?

[Alex]

Your conditional would look more like this:

 

$result = mysql_query("Query to select what you're looking for..");
if(!mysql_num_rows($result))
{
     //Doesn't exist, insert it.
}

[dreamlove]

$result = mysql_query("Query to select what you're looking for..");

$row = mysql_fetch_row($result); 

if(empty($row))

{

    //Doesn't exist, insert it.

}

[dreamlove]

perhaps you can set 'date - depot ' as a unique key in your database.

 

THen , no need to `select`, just `INSERT` directly.

[Miko]

thanks both of the methods are working

 

I could used directly the INSERT query, but this would give errors and our server is logging every error, so I don't like it if my errorlogfile is getting bigger

[PFMaBiSmAd]

... but this would give errors ...

Not necessarily -

 

INSERT IGNORE INTO tbl_name ....