update multiple feilds in table at once

[mbh23]

Currently I have a site that shows items from a database and they can click on the cell and change the info, click save and it updates that cell.  This is done with the code below

 

if($_POST[action]=='updatedivision')
{
	$query="update master set division='{$_POST[updatevalue]}' where id=$_POST[updateid]";
	mysql_query($query) or die("Couldn't update part: ".mysql_error());
}


function makeeditable(cell,id,action,isdisabled)
{
	if(editmode == 1 || isdisabled==1 ) return;
	editmode = 1;
	cell.innerHTML = '<input type=text size=5 id="cell_'+id+'" value="'+cell.innerHTML+'">' +
					'<input type=button value="Save" onClick=\'updatecellcontents('+id+',"'+action+'")\'>';
}
function updatecellcontents(id,action)
{
	document.items.action.value = action;
	document.items.updateid.value = id;
	document.items.updatevalue.value = document.getElementById('cell_'+id).value;
	document.items.submit();
}



<td onclick='makeeditable(this,$row[id],\"updatedivision\",$disableinfo);'>{$row[division]}</td>"

 

How can I make it so they can edit multiple feilds then click on the save button and it will update all of them?

[sm5574]

If you mean update multiple fields of all matching records, it is inherent in the UPDATE syntax structure:

 

http://www.w3schools.com/SQl/sql_update.asp