[SOLVED] insert record to MySQL if the record is NOT in the database else update

[mrprozac]

Hi,

 

I'm writing a search script for my website and want to count the searches, i want to use MySQL for that.

 

I want to insert the search query to MySQL and update the count value.

 

Example.

If 'query1' is not found in the database insert 'query1' in the database, if 'query1' is already present in the database, update the count value with +1 (value + 1)

 

Could someone help me with a script to perform this?

[PFMaBiSmAd]

Look at using an INSERT with the ON DUPLICATE KEY UPDATE clause - http://dev.mysql.com/doc/refman/5.0/en/insert.html

[mrprozac]

Look at using an INSERT with the ON DUPLICATE KEY UPDATE clause - http://dev.mysql.com/doc/refman/5.0/en/insert.html

 

thank you for the quick reply.

I'm going to try it out right away.