updating multiple mysql rows
Posted: Thu May 19, 2005 1:18 pm
Hi all,
A table in my database looks something like this:
I want the user to beable to modify the value "sec" by doing something like this:
How can this be done simply and efficiently?
Thanks.
A table in my database looks something like this:
Code: Select all
id | sec | name
-----------------------
1 | 1 | blah
3 | 2 | blah324
4 | 3 | blah32
5 | 6 | blah234
6 | 4 | blah567
11 | 5 | blah567567
12 | 8 | blah35
13 | 7 | blah46
18 | 9 | blah456
23 | 10 | blah43- Display a form which lists all the $row[name]'s and next to it in a textbox the $row[sec] :-
- blah <1>
blah324 <2>
blah32 <3> ...and so on.
- blah <1>
How can this be done simply and efficiently?
Thanks.