[wd_asp elements=’search’ ratio=’100%’ id=1]

Update Else Insert

20th May 2014

MySql

mysql codehaven category

$result = mysql_query("SELECT * FROM table1 WHERE title_1 ='$title_1' ");

if( mysql_num_rows($result) > 0) {
mysql_query("UPDATE table1 SET time = '$time' WHERE title_1 = '$title_1' ");
}
else
{
mysql_query("INSERT INTO table1 (title_1) VALUES ('$title_1') ");
}