forgive the poor structure of my code, im pretty new at this and havent
figured out exactly what it should be formed like to look its best, anyway
whenever i run this code it works on inserting new information into the
database, however when i want to update the SQL query returns an output like
)
{
$sql = query statement 1;
}else{
$sql = query statement 2;
}
mysql_query($sql);
HTH
Graham
-Original Message-
From: Matthew Kiehne [mailto:[EMAIL PROTECTED]
Sent: 12 October 2004 21:09
To: [EMAIL PROTECTED]
Subject: [PHP-DB] DB will INSERT wont UPDATE..error in code
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