Updating Multiple columns

[fallenangel1983]

hey guys.

 

just wondering is there a way to update multiple columns in a table in one query?

 

e.g. i need to update date time and description all at the same time.

 

im assuming its something like

 

UPDATE tablename SET DATE ='$newdate' etc etc

 

butim not sure how to word it.

 

would appreciate any help

[mwasif]

Yes, you can.

UPDATE tablename SET 
DATE ='$newdate',
description = '$new_desc'
WHERE id=1

This will update both date and description where id=1. You can add as many field as you can and table has them :-)

[fallenangel1983]

worked fine. thanks a lot