$str=数据库查询结果(字符串,例如"张店区,博山,淄博片区,3号片区")我想查询地址包含这些地区的记录,语句如下:
mysql_query("select * from biao where address in ($str)");提示出错,好像要求是"select * from biao where address in ('张店区','博山','淄博片区','3号片区')"这样的形式,我该怎么处理才能让$str变成这样的形式?
多谢
mysql_query("select * from biao where address in ($str)");提示出错,好像要求是"select * from biao where address in ('张店区','博山','淄博片区','3号片区')"这样的形式,我该怎么处理才能让$str变成这样的形式?
多谢
$array = array('张店区','博山','淄博片区','3号片区');
$str = implode(",",$array);
mysql_query("select * from biao where address in ($str)");
$str = "'".implode("','",$array)."'";
mysql_query("select * from biao where address in (".join(',',$array).")");
$a2=arrya[1];
类推下去