Jason thanks, I completely forgot about trying echo $sql by using that I found where it was messing up. Thanks again.
Lee "Jason Wong" <[EMAIL PROTECTED]> 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!! > */ > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php