Hello, First of all , sorry if my question sounds foolish , i am new to php . I have the following code that generates a syntax error on line 13 and i am trying to find a solution for a few hours now ..any help is appreciated. <?php $referrer = $_SERVER['HTTP_REFERER']; if(preg_match("/[\.\/](google|yahoo|bing|geegain|mywebsearch|ask|alltheweb)\.[a-z\.]{2,5}[\/]/i",$referrer,$search_engine)){ $referrer_query = parse_url($referrer); $referrer_query = $referrer_query["query"]; $q = "[q|p]"; preg_match("/".$q."=(.*?)&/",$referrer,$keywords); $keywords = urldecode($keywords[1]); if(isset($keywords)){ $result = mysql_query ("SELECT number FROM keywords WHERE keywords="$keywords" limit 1") or die (mysql_error()); $check = mysql_num_rows($result); if ($check=="0") { $new_row = mysql_query("INSERT INTO keywords VALUES ('1','$keywords')"); } else { $update=mysql_query("UPDATE keywords SET number=number+1 WHERE keywords="$keywords""); } } } ?> Code (markup): Thank you.
$result = mysql_query ("SELECT number FROM WHERE keywords="$keywords" limit 1") or die (mysql_error()); should be $result = mysql_query ("SELECT number FROM WHERE keywords='$keywords' limit 1") or die (mysql_error());
also using `` for column name is advisable $result = mysql_query ("SELECT number FROM WHERE `keywords`='$keywords' limit 1") or die (mysql_error());