mysql_query()期望参数2为资源，字符串在 [英] mysql_query() expects parameter 2 to be resource, string given in

问题描述

可能重复:
mysql_fetch_array()期望参数1成为资源，在select中给出布尔值

Possible Duplicate:
mysql_fetch_array() expects parameter 1 to be resource, boolean given in select

这行怎么了?

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 :

警告:mysql_query()期望参数2为资源，第23行给出的字符串

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

这是我的完整代码

<?php
// 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<$n; $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'); 
}


?> 

推荐答案

这是因为语法不正确，您在INSERT查询中的列名不应用引号引起来:try

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()";

这篇关于mysql_query()期望参数2为资源，字符串在的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！