Code: Select all
ON DUPLICATE ENTRY UPDATE `freq`=`freq`+1Code: Select all
$keyword=mysql_query("INSERT INTO `search_queries` (`query`, `freq`) VALUES ('$keyword', `freq`)")or die("Insert Error: ".mysql_error());Moderator: General Moderators
Code: Select all
ON DUPLICATE ENTRY UPDATE `freq`=`freq`+1Code: Select all
$keyword=mysql_query("INSERT INTO `search_queries` (`query`, `freq`) VALUES ('$keyword', `freq`)")or die("Insert Error: ".mysql_error());Code: Select all
$keyword=mysql_query("INSERT INTO `search_queries` (`query`, `freq`) VALUES ('$keyword', `freq`) ON DUPLICATE KEY UPDATE `freq` = `freq` + 1")or die("Insert Error: ".mysql_error());Code: Select all
ENTRY