Re: Syntax Help
| From: | conbud | Date: | Thu, 14 Nov 2002 20:17:07 +0000 |
| Subject: | Re: Syntax Help | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-124483@lists.php.net to get a copy of this message | ||
Jason thanks,
I completely forgot about trying echo $sql by using that I found where it
was messing up. Thanks again.
Lee
"Jason Wong" <php-general@gremlins.biz> wrote in message
news:200211141725.47510.php-general@gremlins.biz...
> On Thursday 14 November 2002 17:22, conbud wrote:
> > Whats wrong here ?? The variables are getting the correct information
from
> > the form but for some reason as soon as I put the variables into the
$sql
> > they dont post the proper data to the database, its connecting to the
> > database ok but just not updating the data.
> >
> > $sql = "UPDATE updates SET member= '{$_POST['mem']}', email=
> > '{$_POST['email']}', position= '{$_POST['pos']}',
> > dateadded=
> > '{$_POST['dateadded']}', descp=
> > '{$_POST['descp']}', message=
> > '{$_POST['message']}' where id=
> > '{$_POST['id']}'";
> >
> > $result = mysql_query($sql);
>
> Does echo($sql) look OK?
>
> How about echo mysql_error()? Or executing $sql in the mysql command line
> interface?
>
> --
> Jason Wong -> Gremlins Associates -> www.gremlins.biz
> Open Source Software Systems Integrators
> * Web Design & Hosting * Internet & Intranet Applications Development *
>
> /*
> SANTA CLAUS comes down a FIRE ESCAPE wearing bright blue LEG WARMERS
> ... He scrubs the POPE with a mild soap or detergent for 15 minutes,
> starring JANE FONDA!!
> */
>