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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 16, 2003 4:02 PM
Subject: [PHP-DB] 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

Reply via email to