Posted: Sun Oct 29, 2006 11:30 am
Thanks timvwtimvw wrote:Since you've discovered the joy of using sprintf: http://www.timvw.be/elegantly-generate-sql-queries/
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Thanks timvwtimvw wrote:Since you've discovered the joy of using sprintf: http://www.timvw.be/elegantly-generate-sql-queries/
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());
}