Page 2 of 2

Posted: Sun Oct 29, 2006 11:30 am
by John Cartwright
timvw wrote:Since you've discovered the joy of using sprintf: http://www.timvw.be/elegantly-generate-sql-queries/
Thanks timvw :)

Posted: Sun Oct 29, 2006 10:25 pm
by thiscatis
i did it like this,
may not be the most elegant solution, but does the trick

Code: Select all

if($_POST['submit']) {
		
		$arr = array();
		array_push($arr, $_POST['sitename']);
		array_push($arr, $_POST['siteurl']);
		array_push($arr, $_POST['siteowner']);
		array_push($arr, $_POST['rootemail']);
		array_push($arr, $_POST['rootpass']);
		array_push($arr, $_POST['licensetype']);
		array_push($arr, $_POST['rootadress']);
		array_push($arr, $_POST['rootzip']);
		array_push($arr, $_POST['rootcity']);
		array_push($arr, $_POST['rootphone']);
		array_push($arr, $_POST['rootpaypal']);
		array_push($arr, $_POST['rootbankwire']);
		array_push($arr, $_POST['rootcountry']);
		array_push($arr, $_POST['rootbankname']);
		array_push($arr, $_POST['rootbankiban']);
		array_push($arr, $_POST['rootbankswift']);
		
		for ($i = 1; $i <= count($arr)  ; $i++){
			mysql_query("UPDATE cms_settings SET value='".$arr[$i-1]."' WHERE setting_id=".$i ) or die(mysql_error());
   }