N条SQL语句除了查询的变量其他都是一样的，而变量是根据上一条sql查询出来的，有没有什么方法直接一个循环搞定

clover_lu 2016-01-13 01:43:31



 

                $result = mysql_query("SELECT  * FROM `specific` where  name1='$c' or name0='$c' ");

                 $namer1=array();

		  while($info=Mysql_fetch_array($result)){

			$namer1[]=$info['name'];  

		  }

		  $namer1i=implode("','", $namer1);

	

		 

		 $namer2=array();

		 $resultr2 = mysql_query("SELECT  * FROM `specific` where  name1 in ('$namer1i') or name0 in ('$namer1i') "); 

         while($info2=Mysql_fetch_array($resultr2)){

			$namer12[]=$info2['name'];  

		  }

		  $namer2i=implode("','", $namer2);

		

		  

		   $namer3=array();

		 $resultr3 = mysql_query("SELECT  * FROM `specific` where  name1 in ('$namer2i') or name0 in ('$namer2i') "); 

         while($info3=Mysql_fetch_array($resultr3)){

			$namer13[]=$info3['name'];  

		  }

		  $namer3i=implode("','", $namer3);

		  

		  $namer4=array();

		 $resultr4 = mysql_query("SELECT  * FROM `specific` where  name1 in ('$namer3i') or name0 in ('$namer3i') "); 

         while($info4=Mysql_fetch_array($resultr4)){

			$namer14[]=$info4['name'];  

		  }

		  $namer4i=implode("','", $namer4);

		  

		  

		  $namer5=array();

		 $resultr5 = mysql_query("SELECT  * FROM `specific` where  name1 in ('$namer4i') or name0 in ('$namer4i') "); 

         while($info5=Mysql_fetch_array($resultr5)){

			$namer15[]=$info5['name'];  

		  }

		  $namer5i=implode("','", $namer5);

		  

		  

		  $namer6=array();

		 $resultr6 = mysql_query("SELECT  * FROM `specific` where  name1 in ('$namer5i') or name0 in ('$namer5i') "); 

         while($info6=Mysql_fetch_array($resultr6)){

			$namer16[]=$info6['name'];  

		  }

		  $namer6i=implode("','", $namer6);

		  

		  

		  $namer7=array();

		 $resultr7 = mysql_query("SELECT  * FROM `specific` where  name1 in ('$namer6i') or name0 in ('$namer6i') "); 

         while($info7=Mysql_fetch_array($resultr7)){

			$namer17[]=$info7['name'];  

		  }

代码的意思就是不停展开一个包，包里面可能有文件或者还有包，一直展开包，一直展开到只有文件的时候停下来。
上面代码其实sql语句只有一条
SELECT * FROM `specific` where name1 in ('$xx') or name0 in ('$xx')
最开始的$c是用户输入的，这个不用管，其他$xx都是根据上一条查询语句查询出来的，然后再把查出的数据放在下一条相同的sql语句里继续进行查询，有什么好的方法能让它们更快速的执行吗？比如循环？一直查到这条语句为空时就行

...全文

161 8 打赏收藏转发到动态举报

写回复

用AI写文章

8 条回复

切换为时间正序

请发表友善的回复…

发表回复

clover_lu 2016-01-14

打赏
举报

引用 5 楼 xuzuning 的回复:

大致这样 function foo($name) { $result = mysql_query("SELECT * FROM `specific` where name1 in ('$name') or name0 in ('$name') "); $namer = array(); while($info=Mysql_fetch_array($result)){ $namer[] = $info['name']; } $nams = implode("','", $namer); return foo($names); }

好的，谢谢

lirenbing01 2016-01-13

打赏
举报

在mysql里或者php都可以递归老大给的demo你得改改不然

xuzuning 2016-01-13

打赏
举报

大致这样 function foo($name) { $result = mysql_query("SELECT * FROM `specific` where name1 in ('$name') or name0 in ('$name') "); $namer = array(); while($info=Mysql_fetch_array($result)){ $namer[] = $info['name']; } $nams = implode("','", $namer); return foo($names); }

clover_lu 2016-01-13