[Resolved] INSERT or UPDATE?

[Dolemite50]

Hello,

Is there an easy way to have a query check to see if an index id # already exists so that it know whether to use INSERT or UPDATE?

I've been doing something along these lines,..querying to see if it exists first.

Select INDEX_ID from table where INDEX_ID = '$indexid';
blah blah
if(mysql_num_rows){
UPDATE table,..
}
else{
INSERT INTO table...
}

This seems like a lot of additional steps, any thoughts?

[TheDefender]

No, that's pretty much the best route...

You could combine your query with your mysql_num_rows within the if/else to consolidate it a bit, but other than that, that's about the best way to do it...

if(mysql_num_rows("SELECT yadda") != 0) {
update
} else {
insert
}

[Dolemite50]

Thanks Homer, that'll help!