UPDATE and INSERT in mysql

[deep]

Hello,

Im trying to do this: if a column exists then update it, if it does not exist insert it. This is my code (and its not working):

if(!($q = mysql_query($sql_update))){
   mysql_query($sql_insert);

not working... Noticed that mysql_query($sql_update) returns 1 even if the column does not exist... should it not return false in that case??

Thanks.

[deep]

Okay this works 🙂

$qUp = mysql_query($sql_update);
if(mysql_affected_rows() == 0){
   $qIn = mysql_query($sql_insert);
}

Anyone got a better or faster solution? 🙂

[bbreslauer]

What mysql_query() returns is not whether the row was updated or not, but whether the query was executed successfully or not. Therefore, in your first post, it's returning 1 because the query was executed, not because a row was updated.

I think you second post works about as quickly as it's going to.