Sytax Error

Discussion in 'PHP' started by tzaphoo, Feb 7, 2012.

  1. #1
    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.
     
    tzaphoo, Feb 7, 2012 IP
  2. EricBruggema

    EricBruggema Well-Known Member

    Messages:
    1,740
    Likes Received:
    28
    Best Answers:
    13
    Trophy Points:
    175
    #2
    $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());
     
    EricBruggema, Feb 7, 2012 IP
  3. arpit13

    arpit13 Well-Known Member

    Messages:
    294
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    128
    Digital Goods:
    1
    #3
    also using `` for column name is advisable
    $result = mysql_query ("SELECT number FROM WHERE `keywords`='$keywords' limit 1") or die (mysql_error());
     
    arpit13, Feb 8, 2012 IP