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
