On Wednesday 13 October 2004 04:08, Matthew Kiehne wrote:

> database, however when i want to update the SQL query returns an output
> like this 'SQL statement = UPDATE badges
> (staff,ttlpst,mnthpst,ttlicon,mnthicon) VALUES
> ('1','1','1','/ribbons','/ribbons') WHERE fid=2' but when i try to pull the
> information from the database it hasnt updated, can someone help me out
> with this...im not sure why it wouldnt update even though the statement
> looks correct.

I don't see how you get the above output when $sql is defined like so:

>  $sql = "UPDATE badges SET staff = '".$HTTP_POST_VARS["staff"]."' ttlpst =
> '".$HTTP_POST_VARS["ttlpst"]."' mnthpst = '".$HTTP_POST_VARS["mnthpst"]."'
> ttlicon = '".$HTTP_POST_VARS["ttlicon"]."' mnthicon =
> '".$HTTP_POST_VARS["mnthicon"]."' WHERE fid = $fid";

echo $sql;

Make use of mysql_error().

Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
Search the list archives before you post
There are three things I always forget.  Names, faces -- the third I
can't remember.
                -- Italo Svevo

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to