Re: db insert question

[James Benson <jb@xxxxxxxxxxxxxxxxx>]

Thanks for all your help, ive got it working as i needed, my db query is 
built like this, works but probably not the best way of doing it:-



$sqlStart = "INSERT INTO `tester` (";
$sqlMiddle = ") VALUES (";
$sqlEnd = ")";

$keys = array();
$values = array();


		foreach($formData as $keyName => $keyValue){
		  array_push($keys, "`$keyName`");
		  array_push($values, "'$keyValue'");
		}
		
		
$keys = implode(",", $keys);
$values = implode(",", $values);


$query = "$sqlStart$keys$sqlMiddle$values$sqlEnd";
$result = mysql_query($query);

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php