解决方案 »
- 用一个页面接收处理两个不同编码的页面传来的数据
- 实在没办法了,只好上来此求助!关于ZendStudio Debug的问题!
- 关于列表/菜单递交的验证页面的问题
- 【有没有用内存虚拟磁盘做web document root的?】
- YY的,百度贴吧究竟是怎么造出来的?能承受这么高的访问量??
- Mysql罢工,该怎么办?
- WIN2000下怎样使PHP能发邮件?
- 高手请进!!!!!
- 想请教一下wampserver开gzip的问题
- php正则表达式如何获取内容中的视频地址和标题??急
- 网页显示1000多行的表格时缓慢,有什么办法解决?
- 一个frame怎么一运行就是你想打开或者保存文件吗?我点打开还是打不开,他已经保存了
$list .= "'" . $nm['xm'].($i+1) . "'" .',';并不会循环,而且提示错误,没有能获取到任何数据,查询失败
$car = array('name'=>array(0=>array('xm'=>'我是特别的'),1=>array('xm'=>'你好'), 2=>array('xm'=>'你好'), 3=>array('xm'=>'你好')));
if(!$car['name']){
$list='Nothing';
}else{
$i = 1;
foreach($car['name'] as $nm)
{
if(strstr($list,$nm['xm']) && $i == 1)
{
$list = str_replace($nm['xm'],$nm['xm'].$i,$list);
$list .= "'" .$nm['xm'].($i+1). "'";
$i++;
}else{
if(strstr($list,$nm['xm']))
{
$list .= "'" .$nm['xm'].($i+1). "'" ;
$i++;
}else{
$list .= "'" .$nm['xm']. "'" .',';
}
}
}
}$list输出结果为:'我是特别的','你好1','你好2','你好3',但是$sql="SELECT * FROM table where table.title in ($list) limit 0,10";依然查询不到任何数据
可以确认,title有输出的结果,因为如果使用:$list ="'我是特别的','你好1','你好2','你好3'";
$sql="SELECT * FROM table where table.title in ($list) limit 0,10";
的话,以上sql语句是可以查询出来的
$list ="'我是特别的','你好1','你好2','你好3'";
$sql="SELECT * FROM table where title in ($list) limit 0,10";
$mysql_server_name='localhost';
$mysql_username='root';
$mysql_password='123456';
$mysql_database='test';
$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password,$mysql_database);
mysql_select_db('456789');
mysql_query("SET NAMES UTF8",$conn);
$list="'我是特别的','你好1','你好2','你好3'";
$sql="SELECT * FROM table where table.title in ($list) limit 0,10";
$result=mysql_query($sql,$conn);
while($submit = mysql_fetch_array($result)) {
echo $submit["id"];
echo $submit["title"]."<br>";
}
输出结果为:10我是特别的<br>11你好1<br>12你好2<br>13你好3<br>
$mysql_server_name='localhost';
$mysql_username='root';
$mysql_password='123456';
$mysql_database='test';
$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password,$mysql_database);
mysql_select_db('456789');
mysql_query("SET NAMES UTF8",$conn);
$list="";
$car = array('name'=>array(0=>array('xm'=>'我是特别的'),1=>array('xm'=>'你好'), 2=>array('xm'=>'你好'), 3=>array('xm'=>'你好')));
if(!$car['name']){
$list='Nothing';
}else{
$i = 1;
foreach($car['name'] as $nm)
{
if(strstr($list,$nm['xm']) && $i == 1)
{
$list = str_replace($nm['xm'],$nm['xm'].$i,$list);
$list .= "'" .$nm['xm'].($i+1). "'";
$i++;
}else{
if(strstr($list,$nm['xm']))
{
$list .= "'" .$nm['xm'].($i+1). "'" ;
$i++;
}else{
$list .= "'" .$nm['xm']. "'" .',';
}
}
}
}
$sql="SELECT * FROM table where table.title in ($list) limit 0,10";
$result=mysql_query($sql,$conn);
while($submit = mysql_fetch_array($result)) {
echo $submit["id"];
echo $submit["title"]."<br>";
}其中$list输出结果为:'我是特别的','你好1','你好2','你好3'
但是mysql提示错误:mysql_fetch_array(): supplied argument is not a valid MySQL result resource
$car = array('name'=>array(0=>array('xm'=>'我是特别的'),1=>array('xm'=>'你好'), 2=>array('xm'=>'你好'), 3=>array('xm'=>'你好')));
if(!$car['name']){
$list='Nothing';
}else{
$i = 1;
foreach($car['name'] as $nm)
{
if(strstr($list,$nm['xm']) && $i == 1)
{
$list = str_replace($nm['xm'],$nm['xm'].$i,$list);
$list .= "'" .$nm['xm'].($i+1). "'";
$i++;
}else{
if(strstr($list,$nm['xm']))
{
$list .= "'" .$nm['xm'].($i+1). "'" ;
$i++;
}else{
$list .= "'" .$nm['xm']. "'" .',';
}
}
}
}
这样,但是这样并不能查询出任何数据,提示:mysql_fetch_array(): supplied argument is not a valid MySQL result resource
$sql="SELECT * FROM table where table.title in ($list) limit 0,10";
我让你贴出
echo $sql;
的结果!拿到就那么难吗?
不好意思,理解错误