即使你得到了"select * from testa;select * from testb;select * from testc"也不会得到正确的结果,因为在mysql_query()每次只能执行一条SQL,你这样连接起来是三条写成这样: select * from testa,testb,testc
$str1="select * from testa"; $str2="select * from testb"; $str3="select * from testc"; $$querystr;for($i=1;$i<4;$i++) { $querystr = "str$i"; mysql_query($$querystr );}
对啊,我的意思就是让他一次只执行一条啊 换个例子说明我的意图: $str1="select look_a,look_b from test"; $str2="select see_a,see_b from testb"; $str3="select xxx from ccc where xxx<>''";for ($i=1;$i<=2;$i++) { //////////下面我想让它依次执行“上面的每一条sql,然后打印” $rs=mysql_query("\$str$i"); $row=mysql_fetch_array($rs); if (mysql_num_rows($rs)>=1) { echo "......."; } }
哇塞: shanfeng888() 正解,给分!
$str1="select * from testa"; $str2="select * from testb"; $str3="select * from testc"; for($i=1;$i<4;$i++) { mysql_query(${'str'.$i});}
select * from testa,testb,testc
$str2="select * from testb";
$str3="select * from testc";
$$querystr;for($i=1;$i<4;$i++)
{
$querystr = "str$i";
mysql_query($$querystr );}
换个例子说明我的意图:
$str1="select look_a,look_b from test";
$str2="select see_a,see_b from testb";
$str3="select xxx from ccc where xxx<>''";for ($i=1;$i<=2;$i++)
{
//////////下面我想让它依次执行“上面的每一条sql,然后打印”
$rs=mysql_query("\$str$i");
$row=mysql_fetch_array($rs);
if (mysql_num_rows($rs)>=1)
{
echo "......."; }
}
shanfeng888() 正解,给分!
$str2="select * from testb";
$str3="select * from testc";
for($i=1;$i<4;$i++)
{
mysql_query(${'str'.$i});}