Bulk update

[canadabeeau]

Hi I am developing a bulk update script, which is below

function db_update($table){
$mysqli = db_connect();
$query = "UPDATE $table SET ";
foreach($_POST as $aKey=>$aValue){
	while($aValue){
		$query = $query . " `value` = '$aValue' WHERE `tag`='$aKey'";
		$mysqli->query($query) or die("My SQL didn't work in update query." . mysql_error() . $query. '<br><hr>');  
	}
}
}

 

It works by retrieving the name of each POST (eg 'date') and then inserts it into the coulmn 'value' where tag = date

now the problem is the above is not working properly, it is not making one query per $_POST and I need it to do that for it to work as you cant have multiple WHERE clauses for the one query

 

Any help is greatly appreciated

[canadabeeau]

okay guys I now have this

function db_update($table){
$mysqli = db_connect();
foreach($_POST as $aKey=>$aValue){
	while($_POST){
		$query = "UPDATE $table SET ";
		$query = $query . " `value` = '$aValue' WHERE `tag`='$aKey'";
		$mysqli->query($query) or die("My SQL didn't work in update query." . mysql_error() . $query. '<br><hr>');  
	}
}
}

 

which sort of works but results in

Fatal error: Maximum execution time of 30 seconds exceeded

 

So I need a faster way, or better way

 

Thanks

 

 

[DavidAM]

I don't know why you have the while($_POST) inside that loop.  It will always evaluate to true, so you are doing the update for the first POST key over and over again; that's why you got the execution time error.  Remove this while loop, and I think it is doing what you want.

[canadabeeau]

Thanks so much