By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,631 Members | 1,576 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,631 IT Pros & Developers. It's quick & easy.

Edit mysql record

P: n/a
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
Jul 17 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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/
Jul 17 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.