Fancy way to update dbrecord, or insert when no update was done

[Desdinova]

I want to update a table (Table1) and set it's Count column to Count + 1, where the UserID column is 3. However, if there is no UserID column, I would like a record to be created, with Count set to 1.

Of course I could try selecting 1 record from Table1, and if mysql_num_rows is 0, I do one thing, and else I'll do another. I'd love to have this in one query though, if that's possible.

Besides that, I might be able to use mysql_affected_rows.

Does anyone have any suggestions for this?

[bpat1434]

You want INSERT .... ON DUPLICATE KEY UPDATE ...

INSERT INTO `Table1` (`userID`, `Count`) VALUES ('$userID', 1)
ON DUPLICATE KEY UPDATE `Count`=`Count`+1

Note that "userID" has to be a UNIQUE or PRIMARY KEY indexed column. otherwise it won't work.

[Desdinova]

ah thanks. I'll give that a try