Re: PHP and MySQL

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 */