Re: db insert question
| From: | James Benson | Date: | Thu, 21 Jul 2005 15:02:07 +0000 |
| Subject: | Re: db insert question | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-219127@lists.php.net to get a copy of this message | ||
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);