I'm no 'expert' (opening myself up for much criticism here) but try the
following:
(I'm assuming you are setting $fid somewhere)
if (empty($form_status))
{
$staff = $_POST[staff];
$ttlpst = $_POST[ttlpst];
$mnthpst = $_POST[mnthpst];
$ttlicon = $_POST[ttlicon];
$mnthicon =
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
sorry this is the output i meant to post
SQL statement = UPDATE badges SET staff = '1' ttlpst = '1' mnthpst = '1'
ttlicon = '/trophies' mnthicon = '/ribbons' WHERE fid = 61
and this is the error i getyet i still cant for the life of me find a
problem
Update query = UPDATE badges SET staff =
Please do not top-post.
On Wednesday 13 October 2004 10:26, Matthew Kiehne wrote:
sorry this is the output i meant to post
SQL statement = UPDATE badges SET staff = '1' ttlpst = '1' mnthpst = '1'
ttlicon = '/trophies' mnthicon = '/ribbons' WHERE fid = 61
and this is the error i getyet i
Jason Wong [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
If you look up the manual entry for UPDATE, you'll find that you're
missing
the commas separating the columns.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design
