Re: [PHP] db insert question

[James Benson]

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