multiple update records with php?

updating multiple records on a single page, using mySQL / PHP?

Hi,

any ideas on updating multiple records on a single page, using mySQL / PHP? I have seen some solutions for ASP, but not for PHP.

I would like to have a dynamic table developed from a recordset, where the left column for each recdord is set, but the right column is changeable (like a text box).

cheers, andrew

Comments

Mulitple update with ASP | SQL

December 5, 2003 by Rasmus Pedersen

do u know if there exists any multiple update Extension for ASP|SQL

this window i do my post in - what extension is that ?

nobody?

August 27, 2004 by travis maraca

I see this done all the time, although I'm not quite ninja enough to write a tutorial or extension.. i'm surprised nobody has stepped up to answer this common question!

ImpAKT

January 26, 2005 by Chris Charlton

Update Many-To-Many Form: http://www.interaktonline.com/Products/Dreamweaver-Extensions/ImpAKT/Features/Details/Update+Many-To-Many+Form.html?id_ftr=13 Insert Many-To-Many Form: http://www.interaktonline.com/Products/Dreamweaver-Extensions/ImpAKT/Features/Details/Insert+Many-To-Many+Form.html?id_ftr=12

this is the way i done it.

December 14, 2005 by albescu ioan

'; while ($row = mysql_fetch_array($result)) { $users = $row; echo '

'; echo ''; echo $users["nume"]; echo '

'; } echo ''; echo ''; if (isset($_GET['perm'])) { $perm = $_GET['perm']; foreach ($perm as $userid) { //you can use the next line for control to see if id works every time //echo '
'.$userid.' is set'; // i just show them but you can update, delete whatever you want on the $userid field. $query1 = "select * from test where test.id = '$userid'"; $result1 = mysql_query($query1); while ($row1 = mysql_fetch_array($result1)) { echo $row1["nume"]." is set
"; } } } else { echo '
None are set'; } ?>

See all 6 Comments

You must me logged in to write a comment.