Jump to content

If Not Exist Update ELSE Insert


php_guest

Recommended Posts

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.

Link to comment
https://forums.phpfreaks.com/topic/144616-if-not-exist-update-else-insert/
Share on other sites

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 )
    }

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.