获得链接id参数利用sql语句并查找

Question

a.php:<?php
$con = mysql_connect("localhost:3306","root","123456") or die("数据库连接失败".mysql_error());
mysql_select_db("vote",$con) or die ("数据库选择失败".mysql_error());
mysql_query("set names utf8");
?>

<?php
    for($i = 0; $i < 8; $i++)
    {?>  
        <a href="b.php?id=
        <?php
            $a = mysql_query("select date from brief limit $i,1");
            $b = mysql_fetch_array($a);
            echo $b["date"];
        ?>"class="link" target="_blank" title="督导简报">2</a>
<?php }?> 

b.php:
<?php
$con = mysql_connect("localhost:3306","root","123456") or die("数据库连接失败".mysql_error());
mysql_select_db("vote",$con) or die ("数据库选择失败".mysql_error());
mysql_query("set names utf8");
?>

<?php
    for($i = 0; $i < 8; $i++)
    {?>  
        <a href="b.php?id=
        <?php
            $a = mysql_query("select date from brief limit $i,1");
            $b = mysql_fetch_array($a);
            echo $b["date"];
        ?>"class="link" target="_blank" title="督导简报">2</a>
<?php }?> 

只对第一个id的参数进行查询怎样让他查询id的第二个参数？？？？

Answer 1

不是有for循环吗。判断下标不就行了，虽然我不怎么懂PHP