$query= "SELECT name from table where id =_$POST[$id]";
修改成
where id={$_POST[$id]};
或者将变量在外部赋值
$id=$_POST[$id];
$query="SELECT name FROM table WHERE id={$id}";
$result=mysql_query($query);
w……
[/Quote]
$TradeName= $_POST["TN"];
$query_CN = "SELECT Pestcide_trade_name,Company_name from insecticide where Company_name={'$TradeName'};";
$q_result_CN = mysql_query($query_CN);
while($each_ques_CN = mysql_fetch_row($q_result_CN))
{ print $each_ques_CN[0];}
PhpNewnew按你的方法改了,可错误提示依然在:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in d:\apm_setup\htdocs\search.php on line 33
$TradeName= $_POST["TN"];
$query_CN = "SELECT Pestcide_trade_name,Company_name from insecticide where Company_name={'$TradeName'};";
$q_result_CN = mysql_query($query_CN);
while($each_ques_CN = mysql_fetch_row($q_result_CN))
{ print $each_ques_CN[0];}
PhpNewnew按你的方法改了,可错误提示依然在:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in d:\apm_setup\htdocs\search.php on line 33
$query= "SELECT name from table where id =_$POST[$id]";
修改成
where id={$_POST[$id]};
或者将变量在外部赋值
$id=$_POST[$id];
$query="SELECT name FROM table WHERE id={$id}";
$result=mysql_query($query);
while($re=mysql_fetch_assoc($result){
//输出
print_r($re);
}