Cheers to everyone...
the curly brackets was me not thinking after a boozy lunch, and trying to
recreate code, on an E-mail..
anyhoo...
I thought the best idea, and the simplest for me, was to remove the ' from
the session recall
Turning $_SESSION['salutation'] --> INTO --> $_SESSION[salutation]
Cheers all...
it's clear as day now...
aint it always the way eh?
Tris...
George Patterson <george@visp.com.au> wrote on 16/10/2003 14:15:54:
> 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...
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
*********************************************************************
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.
***********************************************************************
