mysql_query第二参数,mysql_query（）期望参数2为资源，字符串在

what's wrong with this line?

23. $result = mysql_query("INSERT INTO $tbl_name('city_id', 'city', 'state_id') VALUES('NULL, '.$city.","', '4421'') or die(mysql_error())");

I get this error message each time :

Warning: mysql_query() expects parameter 2 to be resource, string given in line 23

This my full code

// Get values from form

$city = explode(',', $_POST['city']);

//create a loop

if(isset($_POST['city'])) {

$city = explode(',', $_POST['city']);

$n = count($city);

for($i=0; $i

$result = mysql_query("INSERT INTO $tbl_name(city_id, city, state_id) VALUES(NULL, '.$city.","', '4421')") or die(mysql_error());

}

} if($result) {

header('Location: index.html');

}

?>

解决方案

This is because of incorrect syntax and you column names in INSERT query should not be enclosed in quotes: try

$result = mysql_query("INSERT INTO ".$tbl_name."(city_id, city, state_id) VALUES(NULL, '".$city."','4421') or die(mysql_error()";