On Thursday 12 December 2002 09:22, BABA Yoshihiko wrote: > Jason Wong wrote: > > Not sure why you're escaping the single quote. It's unnecessary -- and I > > suspect you mis-escaped $select as well. Any you can use this format, > > which IMHO, is a lot easier on the eyes: > > > > $sql = "INSERT INTO `guest` > > SET `title` = '$title', > > `first_name` = '$first_name', > > ..., > > ..., > > `last_visit` = NOW()"; > > Can you use SET with INSERT INTO? Is it MySQL grammer?
Yes. It's something that I miss when using PostgreSQL. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* I didn't get sophisticated -- I just got tired. But maybe that's what sophisticated is -- being tired. -- Rita Gain */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php