RE: [PHP-DB] Re: MySQL version issue
-Original Message- From: Doug Thompson [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 05, 2005 8:44 AM I isn't my intention to start a peeing contest, but if *you* get rid of the chip and actually read the manual excerpt, the equivalent SQL statements it cites are very definitely available in mysql 3.xx.xx. This will be brief, because this is rolling towards non-productiveness - but, while you are technically right - it's still not an answer for him. The new feature us do this OR (IF CONDITION) that and the equivalent statement is do that with the precondition of (IF CONDITION). Of course the relevant SQL statements are available to independently insert or update, it'd be pretty useless without. So, yeah - solution is to bring the logic into the app, or get a new host. 'nuff said. Cheers, - 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
Re: [PHP-DB] Re: MySQL version issue
I isn't my intention to start a peeing contest, but if *you* get rid of the chip and actually read the manual excerpt, the equivalent SQL statements it cites are very definitely available in mysql 3.xx.xx. DT Mark Benson wrote: Doug, read my e-mail again, specifically the second and third paragraphs about what *version* of MySQL my host's server is using, then look at the manual entry again (specifically the first line you quoted). The _mysql manual_ says... If you specify the ON DUPLICATE KEY UPDATE clause (new in MySQL 4.1.0) thus it only works in 4.1.0 and later, and my host is running MySQL 3.23.58 (not 3.25.58 as I previously said, not that it makes much odds!). Anyhoo thanks for giving it a shot, RBR (read before replying) in future, there's a good chap ;o) Bastien, thanks sometimes one needs a new perspectiuve on these things, I was stuck in my mysql_query brackets. Putting mind to matter using your tips it would actually be fairly simple to do that. Again thank you for providing an exit() to my stuck loop ;o) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php