由于需要多次查询数据库,需要建立一个返回查询值的函数,可是总是会返回错误,错误如下:Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in D:\php\website\Web_en\inc\product_list_directory.php on line 16返回错误的16行为:$row=mysql_fetch_row($result_addr);函数代码如下:
function Getparentcode($urlstring,$conn){
$result_addr=mysql_db_query($mysql_database,"select * from product_category where cat_code like '".$searchstring."'",$conn);
$row=mysql_fetch_row($result_addr);
return $row[11];
mysql_free_result($result_addr);
}
function Getparentcode($urlstring,$conn){
$result_addr=mysql_db_query($mysql_database,"select * from product_category where cat_code like '".$searchstring."'",$conn);
$row=mysql_fetch_row($result_addr);
return $row[11];
mysql_free_result($result_addr);
}
function Getparentcode($urlstring,$conn){
$result_addr=mysql_db_query($mysql_database,"select * from product_category where cat_code like '".$urlstring."'",$conn);
$row=mysql_fetch_row($result_addr);
return $row[11];
mysql_free_result($result_addr);
}Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in D:\php\website\Web_en\inc\product_list_directory.php on line 16
$mysql_database也没传值,所以肯定有问题,
mysql_query("select * from product_category where cat_code like '%".$urlstring."%'",$conn);,如果之前选择过数据库或者你加上传值,sql语句也要改一下
function Getparentcode($urlstring,$conn){ //Getparentcode函数参数$urlstring怎么传递的,尽上面的代码没有给出如何使用
$result_addr=mysql_db_query("select * from product_category where cat_code like '%".$urlstring."%'",$conn);
$row=mysql_fetch_row($result_addr);
$result_addr=mysql_db_query($mysql_database,"select * from product_category where cat_code like '%".$urlstring."%'",$conn);
$row=mysql_fetch_row($result_addr);
return $row[11];
mysql_free_result($result_addr);
}
$result_addr=mysql_db_query($mysql_database,"select * from product_category where cat_code like '%".$urlstring."%'",$conn);
要充份利用已有的调试机制$result_addr=mysql_db_query($mysql_database,"select * from product_category where cat_code like '".$searchstring."'",$conn) or die(mysql_error());
式中:$mysql_database、$searchstring 未定义
可临时声明为全局变量再调试
global $mysql_database, $searchstring;
最终的成品中是不能这样写的
作为外部变量或传入参数,你都应该检查
$mysql_database 中的数据库是否存在
$searchstring 中的特殊符号“'”是否被转义