Edit mysql record

[Johan Harms]

I want to use a userform on a webpage so members can edit their data.

Displaying the data on the form isn't the problem.
But when members change their data how do i save then new data in their
record. I dont want a new record.

Johan

[Geoff Berrow]

I noticed that Message-ID:
<af***************************@news.multikabel.n l> from Johan Harms
contained the following:

Displaying the data on the form isn't the problem.
But when members change their data how do i save then new data in their
record. I dont want a new record.

Use and UPDATE query instead of INSERT

UPDATE tbl SET field1='$field1', field2='$field2', field3='$field3'
WHERE rowid='$rowid'

--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/