PHP Mysql Error - Will not add numbers?

S

Samuel

New member
Hello everyone.

I am making a table in a database where I can see what people are searching on my website. It has two columns: "keyword" and "searches". I want it so if a keyword has already been searched the number in the "searches" column goes up by 1. But so far all it is doing is repeating the keyword again with "1" in the "searches" column. (Please say if you don't understand)

Can any of you please help me. Here is the piece of code I am using:

$keyword = $_GET['keyword'];
$keywordexists = mysql_query("SELECT keyword FROM keywordsearch")or die(mysql_error());
$keywordrow = mysql_fetch_array($keywordexists);
if ($keywordrow == $keyword) {
$searches = mysql_query("SELECT searches FROM keywordsearch WHERE keyword = '$keyword'")or die(mysql_error());
$searches = mysql_result($searches,"searches");
$searches1 = $searches+1;
$mysqlsearches = "UPDATE keywordsearch SET searches='$searches1' WHERE keyword='$keyword'";
$add_keyword = mysql_query($mysqlsearches) or die(mysql_error());
} else {
$insert = "INSERT INTO keywordsearch (keyword, searches) VALUES ('$keyword', 1)";
$add_keyword = mysql_query($insert) or die(mysql_error());
}


Any help would be much appreciated, thank you for your time. Merry Christmas.
 
Back
Top