> -----Original Message-----
> From: Mark Benson [mailto:[EMAIL PROTECTED]
> If I try that it returns:
> You have an error in your SQL syntax near 'ON DUPLICATE KEY UPDATE' at
> so I guess something doesn't work there. I also tried it with and
without the line ending and it didn't work either way :).
Are you running a version of mysql >= 4.1.0 ?
"If you specify the ON DUPLICATE KEY UPDATE clause (new in MySQL 4.1.0),
and a row is inserted that would cause a duplicate value in a UNIQUE
index or PRIMARY KEY, an UPDATE of the old row is performed."
Also, note - I was VERY WRONG! You are allowed to follow the statement
with what you want updated - and I believe you're supposed to. I
knee-jerked that first answer, assuming it must be it since the
information was so redundant - my apologies. I expect, however, that
you're not supposed to specify the key again with the update part,
though I suppose it's possible to.
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospital.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php