Re: [PHP] Parse Error on SQL Insert

[Joe Henry]

On Friday 07 April 2006 1:56 pm, Chrome wrote:
> Backticks (`) encapsulate table or database names
>
> I was thinking maybe if the array references were encapsulated in curly
> braces {}:
>
> $_POST['model'] to {$_POST['model']}
>
> Of course if the field in the DB isn't numeric this would be
> '{$_POST['model']}'
>
> Dan
>
> -------------------
> http://chrome.me.uk
>
>
> -----Original Message-----
> From: Joe Henry [mailto:[EMAIL PROTECTED]
> Sent: 07 April 2006 20:53
> To: php-general@lists.php.net; [EMAIL PROTECTED]
> Subject: Re: [PHP] Parse Error on SQL Insert
>
> On Friday 07 April 2006 1:37 pm, Tom Chubb wrote:
> > $insertSQL = "INSERT INTO cars (model, `year`, details, price, image1,
>
> Not sure if this is your problem, but those look like backticks around year
> instead of single quotes. Should there even be quotes there?
>
> HTH
> --
> Joe Henry
> www.celebrityaccess.com
> [EMAIL PROTECTED]
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
> __________ NOD32 1.1475 (20060406) Information __________
>
> This message was checked by NOD32 antivirus system.
> http://www.eset.com

Good to know. Thanks.

-- 
Joe Henry
www.celebrityaccess.com
[EMAIL PROTECTED]

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php