[PHP-DB] update multiple fields in MySQL From: Nick (nick <email protected>)
Date: 07/13/00

hi,

short but sweet.....

how do you update multiple fields at the same time using MySQL ?

as in $query= "update table set name= '$name' AND ID= '$ID' where date= '$date'";

this of course doesn't work....

any ideas ?

-nick