Re: PHP and MySQL

From:	BABA Yoshihiko	Date:	Thu, 12 Dec 2002 01:22:08 +0000
Subject:	Re: PHP and MySQL
References:	1 2	Groups:	php.general
Request:	Send a blank email to php-general+get-127942@lists.php.net to get a copy of this message

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? -- BABA Yoshihiko