updating rows

incarnate

I've got a question,

When I do queries seperatly to update my table they work fine:
"UPDATE table SET cola=cola+$vara WHERE id='$id'"
"UPDATE table SET colb=colb+$varb WHERE id='$id'"
etc...

but when I try to combine them en mass, it's like the query doesn't run at all...
"UPDATE table SET cola=cola+$vara,colb=colb+$varb, (etc.) WHERE id='$id'"

There's about ten variables (numerical values) and ten columns (numerical values) in the row I try to update with in my script. Anyone here know the problem?

Thanks

harmor

Here's something I've used

$sql = mysql_query("UPDATE contact SET name='$name', email='$email', comments='$comments' WHERE id=$id");

Maybe you'll find your problem

incarnate

I mean when I run the queries seperately they work fine, but when I try to combine them, they don't run at all seems like

harmor

and I said maybe you can compare my code to your code and see what you did wrong.

jollyollie

You could set it up outside the query and the use it like so:

$sql = "select * from 'table' where id=$id";
mysql_query($sql);

$newvara=cola+var1;
$newvarb=colb+var2;

$sql = "update 'table' set cola=$newvara, colb=$newvarb where id=$id";
mysql_query($sql);

Just an idea.

incarnate

I'm sure that would work but I want to avoid having to call the values from the table.

Please read my posts thoroughly, "harmor"
When I combine my queries with maybe three like this, it works fine.
"UPDATE table SET cola=cola+$vara,colb=colb+$varb,colc=colc+$varc WHERE id='$id'"

But when I start adding more the query won't run (varies)
FYI, you don't need to set the query as a variable before you run it. I am showing you my queries, not the literal code. cough When do the knowledgable stop by here.

Drakla

Have you got any actual code, as that demo query in the above post is perfect, so should work. The column types are all numeric, aye? What are you using to check the query worked? Reading the values back, or something like mysql_affected_rows? And have you tried echoing the query and checking if there were any errors?