RE: [PHP-DB] Sessions and MySQL?
| From: | Hutchins, Richard | Date: | Thu, 16 Oct 2003 13:05:34 +0000 |
| Subject: | RE: [PHP-DB] Sessions and MySQL? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-31071@lists.php.net to get a copy of this message | ||
In addition to what John suggested, I see you have switched from parens to
curly braces when you close your list of columns and list of values. AFAIK,
you need to use parens to contain those lists.
> -----Original Message-----
> From: CPT John W. Holmes [mailto:holmes072000@charter.net]
> Sent: Thursday, October 16, 2003 9:08 AM
> To: php-db@lists.php.net; Tristan.Pretty@risk.sungard.com
> Subject: Re: [PHP-DB] Sessions and MySQL?
>
>
> From: <Tristan.Pretty@risk.sungard.com>
>
> > And I'm trying to add a session variable to a MySQL database.
> > I've done this page that takes the results from a previous form...
> > But I get this error:
> > Parse error: parse error, expecting
T_STRING' or
> > T_VARIABLE' or
> > `T_NUM_STRING'
> > On line 83
> > Which is the line that relates to the line:
> > \"$_SESSION['salutation'];\",
> >
> > I've tried removing the ';' but it change nothing...?
> > Can anyone see my error?
> >
> > =================
> > <?
> > session_start();
> > header("Cache-control: private");
> >
> > $_SESSION['salutation'] = $_POST['salutation'];
> >
> > //MySQL connection stuff
> > mysql_query("INSERT INTO $table (
> > salutation,
> > name,
> > city
> > } VALUES {
> > \"$_SESSION['salutation'];\",
> \"{$_SESSION['salutation']}\",
> > \"$_SESSION['name'];\",
> \"{$_SESSION['name']}\",
> > \"$_SESSION['city'];\"
> \"{$_SESSION['city']\",
> > }
>
> ---John Holmes...
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>