Thanks Jason, switching the single and double quotes did the trick!
Now, I'm curious - what's the rule of thumb for when using single quotes
and double quotes?
Thanks!
--
Laurie Landry
[EMAIL PROTECTED] - email
(604) 693-1120 - voicemail/fax
---- Jason Wong <[EMAIL PROTECTED]> wrote:
> On Sunday 10 February 2002 00:47, [EMAIL PROTECTED] wrote:
> > I'm trying to set up a "modify record" page, and after testing and
> > triple-checking the syntax and form, and even running the query in
> the
> > phpMyAdmin interface to make sure the query is correct.
> >
> > This is just a snippet of what I've done:
> >
> > <?php
> >
> > // open connection
> > include ("connectdatabase.inc");
> >
> > // format names to protects the O'Haras etc.
> > $esc_fname = addslashes($fname);
> > $esc_lname = addslashes($lname);
> > $esc_email = addslashes($email);
> > $esc_web = addslashes($web);
> >
> > // set up query
> > $sql = 'UPDATE thistable
> > SET FNAME = "$esc_fname", LNAME = "$esc_lname", EMAIL
> > = "$esc_email", WEB = "$esc_web"
> > WHERE ID = "$id"';
>
> If you print/echo $sql at this point you'll (hopefully) see where you're
>
> going wrong.
>
>
> If you don't see what you're doing wrong then swap your single quotes
> for
> double quotes and vice-versa.
>
> --
> Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
>
> /*
> The Killer Ducks are coming!!!
> */
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
