I'm not sure that this code will work.
Try to use $_SESSION['..'] and (..). [Don't use the {, } for this purposes.
vio-
----- Original Message -----
From: "pete M" <pmorgan@ukds.net>
To: <php-db@lists.php.net>
Sent: Thursday, October 16, 2003 4:02 PM
Subject: Re: Sessions and MySQL?
> might seem a bit long winded but this is how I would code it
>
> $sql = "INSERT INTO $table ( salutation, name, city} VALUES {"
> $sql .= "'".$_SESSION{'salutation']."', "
> $sql .= "'".$_SESSION{'name']."', "
> $sql .= "'".$_SESSION{'city']."' ) "
>
> mysql_query($sql);
>
> regards
> pete
>
> mysql_query("INSERT INTO $table (
> > salutation,
> > name,
> > city
> > } VALUES {
> > \"$_SESSION['salutation'];\",
> > \"$_SESSION['name'];\",
> > \"$_SESSION['city'];\"
> > }
> >
>
>
> Tristan Pretty wrote:
>
> > Not sure if this is a MySQL Q. or a PHP one, but here goes...
> >
> > I'm just learning sessions...
> > 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['name'];\",
> > \"$_SESSION['city'];\"
> > }
> >
> > ?>
> > //Rest of page... thanks etc...
> > =================
> >
> > *********************************************************************
> > The information contained in this e-mail message is intended only for
> > the personal and confidential use of the recipient(s) named above.
> > If the reader of this message is not the intended recipient or an agent
> > responsible for delivering it to the intended recipient, you are hereby
> > notified that you have received this document in error and that any
> > review, dissemination, distribution, or copying of this message is
> > strictly prohibited. If you have received this communication in error,
> > please notify us immediately by e-mail, and delete the original message.
> > ***********************************************************************
> >
> >
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
