Re: Syntax Help
| From: | Jason Wong | Date: | Thu, 14 Nov 2002 09:25:47 +0000 |
| Subject: | Re: Syntax Help | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-124393@lists.php.net to get a copy of this message | ||
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!!
*/