Putting information back where it came from

[Milton]

Hi,

I'm currently working with a database where I want to be able to put the information into a specific row (say row "0"), take that information out, change it, and put it back in the SAME ROW that I took it from. I cannot use INSERT INTO because that always makes a new row, and I cannot find a specific command under ALTER TABLE that will enable me to alter the data of the specific cell so that I can put the information back in there.

Any help with this would be appreciated

[cgraz]

UPDATE your_table SET field1='$updated', field2='$updated2', field3='$updated3' WHERE id='$id'

Cgraz