Re: update one column in many records?

Hey Floyd: > I need to update one element of a record, in many records. I would like to do > this all at one time from a screen with a column of input boxes. Is this > possible with arrays? Perhaps one that reads a column instead of a row? Your question is extremely vague. This most likely has to do with properly writing one SQL statement, for example: update tablename set colname='$newvalue' where colname='$oldvalue' or $in = implode(",", $ID_array_from_form); update tablename set colname='$newvalue' where id in ($in) --Dan -- T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y More than just answers. Solutions. (SM) http://www.analysisandsolutions.com/ 4015 7 Av #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409