sql update/insert

[Anon]

I have a form where they can create/delete/modify records and I an currently coding the modify part. I am doing something like this:

SELECT id FROM foo WHERE id="bar";

if I get any results, it exists, so:
UPDATE foo SET id="barf" WHERE id="bar";
else:
INSERT INTO foo VALUES ("barf", null, null);

This method will work, but it seem like this would be so common that there would be a commen that updates a record if it exists, and inserts it otherwise. Does such a command exist?

[Anon]

I just read that, and the last part didn't make sense because I said "would be a commen that updates" but I should have said "would be a command that updates"

sorry

[Anon]

you can use
if ($results)
{
This is if it is results are true
}
if (!$results)
{
This is if the results are not true
}

[Anon]

um...is it just me or is that the same thing as the if/else that I am using?

I understand how to program in php, I was just showing the SQL algo for updating. My only real question is about a [sql] command that does and select/update/insert in one.

[Anon]

sorry 🙁. I cant help you there. If you are good please take a look at my post above, i am having problems, with a select statement