[PHP-DB] sql syntax error

[Addison Ellis]

hello,
i can not pinpoint this. your time and help is very much appreciated. best, addison

Error:
id=, HTTP_POST_VARS=Array, key=, value=, category=, subcategory=, [EMAIL PROTECTED]
Error in query: insert into ads values (year,make,model,color,mileage,condition,price,other,contact,next_,,created) values ('',,NOW()),Error:You have an error in your SQL syntax near 'created) values ('',,NOW())' at line 1

Code:
else { foreach($HTTP_POST_VARS as $column_name => $column_value)

$column_names .= $column_name . ',';
$column_values .= "'$column_values',";

$query = "insert into ads values ($column_names,created)
values ($column_values,NOW())";
$result = mysql_query($query)
or die ("Error in query: $query,Error:" .mysql_error());
}

?>
--
Addison Ellis
small independent publishing co.
114 B 29th Avenue North
Nashville, TN 37203
(615) 321-1791
[EMAIL PROTECTED]
[EMAIL PROTECTED]
subsidiaries of small independent publishing co.
[EMAIL PROTECTED]
[EMAIL PROTECTED]