Re: Re: Sessions and MySQL?

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: [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 >