php_array_to_sql

gistfile1.aw

function arrayToSql($table, $array, $insert = "INSERT INTO") {
	if ($insert != "UPDATE") {
		$insert = "INSERT INTO";
	}	
	$columns = array ();
	$data = array ();
	
	foreach ( $array as $key => $value ) {
		$columns [] = $key;
		if ($value != "") {
			$data [] = "'" . $value . "'";
		} else {
			$data [] = "NULL";
		}
	}
	$cols = implode ( ",", $columns );
	$values = implode ( ",", $data );
	
	$sql = <<<EOSQL
  $insert `$table`
  ($cols)
  VALUES
  ($values)
EOSQL;
	return $sql;
}