> A quick look at the REPLACE syntax tells me that
>
> "REPLACE works exactly like INSERT, except that if an old record in the
> table has the same value as a new record on a unique index, the old
> record is deleted before the new record is inserted."
>
> So if id isn't a unique index, you could expect the values to be added.

The id is a unique index.
But - as often before. Asking something here triggers my brain to work. I
found the problem. I simply forgot a comma in my query:
$query .= " values('$fid''$show_id')";

I got a little disappointed at first when the query started adding
additional values again. But it only did that one time. For some reason it
wanted id to have a row with the value "0". After that it started to replace
the row with id "1". And now it works :)

- Daniel



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to