Re: Parse Error on SQL Insert
| From: | Joe Henry | Date: | Fri, 07 Apr 2006 20:39:22 +0000 |
| Subject: | Re: Parse Error on SQL Insert | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-233481@lists.php.net to get a copy of this message | ||
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:jhenry@celebrityaccess.com]
> Sent: 07 April 2006 20:53
> To: php-general@lists.php.net; tom@ps-promo.co.uk
> 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
> jhenry@celebrityaccess.com
>
> --
> 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
jhenry@celebrityaccess.com