"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
> * W
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 getye
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 = '
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
pdated!\n";
}
}
The echos will at least show the SQL being executed which could give a clue
to the problem.
You could even just set the $sql within the if...else... and use the same
mysql_query($sql) for both instances:
if (condition1)
{
$sql = "query statement 1";
}
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
thi