Updating multiple mysql columns.

[perlone]

Is it possible to update multiple columns at same time? I have this code but it's not updating whenever I update more than 1 column:


$sql = <<EOF;
update user_data
set subscriber = subscriber-1 where (subscriber > 0)
gold=gold+1
points=points+1

EOF

Any ideas? Thanks for reading. There is no Knowledge that is not power.
Age: 16
E-mail: projectnet01@yahoo.com
School: Coral Springs High (

http://www.coralspringshigh.com)

Companynot done yet)
Status: Currently working with C++ for game developing. And making a musical band.
-Aaron

 

[Guest_imported]

Nearly there

update user_data
set subscriber=subscriber-1,
gold=gold+1,
points=points+1
where (subscriber > 0);

 

[perlone]

Thanks! I'll try that. There is no Knowledge that is not power.
Age: 16
E-mail: projectnet01@yahoo.com
School: Coral Springs High (

http://www.coralspringshigh.com)

Companynot done yet)
Status: Currently working with C++ for game developing. And making a musical band.
-Aaron