[RESOLVED] adding into table if it can't be updated

[Ali_baba]

Hello,

How can I add a record into the table if it doesn't exist while updating other records.

Here is the query:

for ($i=1;$i<=$kn;$i++) {
mysql_query("UPDATE ofsp_table SET knpk='$knpk[$i]',knloy='$knloy[$i]' WHERE parid = '$ID' LIMIT 1"); 
} 

This will only update records which already exist. However, what if there's one more record which doesn't exist? I'd like to add that record. How may I do so?

[__ins0__]

you can check first with the "SELECT" Statement and MYSQL_NUM_ROWS if the Record exist.

Result 0 or 1 ... and then you can chose...UPDATE or INSERT 🙂

[Ali_baba]

Thanks ins for your hint.
I didn't know about this function at all 🙂