Problem submitting mysql_query

programming
1

Hi,

I’m having trouble submitting a query through PHP. I want to update multiple rows at once, and my query looks like this (without the line breaks):

UPDATE Table     SET value1='0', value2='5'     WHERE ID='1';
UPDATE Table     SET value1='0', value2='4'     WHERE ID='2';
UPDATE Table     SET value1='4', value2='6'     WHERE ID='3'

This works when I go directly to my SQL database CP and submit the query, but when I try doing it through PHP, it doesn’t work. I ASSUME this is because of the semi-colon ( ; )… or maybe I’m totally wrong.

So can somebody tell me what’s wrong? Thanks a lot!

-45