$a = array('count'=>248217, 'sum' => 22049506.8200, 'time' => '1202788231', 'name' => "Deborah Barber Apo AP^Michael Donnelly Sierra Vista AZ^Jess Prewitt Oneonta NY^Christine Robertson Albuquerque NM"); foreach($a as $k=>$v) { $fieldspec .= mysql_escape_string($k).','; if (is_string($v)) { $valuespec .= "'".mysql_escape_string($v)."',"; } else { $valuespec .= mysql_escape_string($v).','; } } $fieldspec = rtrim($fieldspec, ','); $valuespec = rtrim($valuespec, ','); $query_string = "INSERT INTO $TABLENAME ($fieldspec) VALUES ($valuespec)"; var_dump($query_string);