Re: Sessions and MySQL?

On Thu, 16 Oct 2003 13:33:28 +0100 Tristan.Pretty@risk.sungard.com 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? > Tristan, yes, You are alternating between curly braces {} and parenethes () (spelling??). Also you forgot to the closing double quotes when completeing the mysql_query statement. You could also put the insert statement into a vairable and echo that to the screen. That way if you can't see the error, paste the query text into the mysql command line client. See my alterations to you code below.. Regards George Patterson > ================= > <? > 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...