If Not Exist Update ELSE Insert

[php_guest]

I am trying to make a right syntax but I don't know how. Please help me to correct it:

 

 
mysql_query("IF NOT EXISTS (INSERT INTO users (firstName, lastName, id2, counter) VALUES ('Nick', 'AAAA', '4', '$views')) ELSE (UPDATE users SET firstName='Nick', lastName='AAAA', id2='4', counter='$views' WHERE ID='4')") or die (mysql_error()); 

//or 

mysql_query("IF EXISTS (UPDATE users SET firstName='Nick', lastName='AAAA', id2='4', counter='$views' WHERE ID='4') ELSE (INSERT INTO users (firstName, lastName, id2, counter) VALUES ('Nick', 'AAAA', '4', '$views'))") or die (mysql_error()); 

 

For each search I get data for firstName and lastName and $views.

[dreamwest]

Just use variables...like php would and you also need to SELECT first to check if it exists

 

 

 

    $sql = "SELECT * FROM table WHERE search='".$search_id."' ";
    if ( !( $result = mysql_query( $sql ) ) )
    {
    }
    $search = mysql_num_rows( $result );

    if ( 0 < $search )
    {
        $sql2 = "UPDATE table SET search='".$search_id."' ";
        $result2 = mysql_query( $sql2 )
    }
    else
    {
       
        $sql2 = "INSERT INTO table SET search_query='".$search_id."'";
          $result2 = mysql_query( $sql2 )
    }

[corbin]

You might could use UPDATE INTO.

[aschk]

Or you could use

 

INSERT .... ON DUPLICATE KEY UPDATE ...

 

See the manual for syntax.

http://dev.mysql.com/doc/refman/5.1/en/insert-on-duplicate.html