<?php
    $sql="select * from test";       //查询语句
    $rs=new com("adodb.recordset");     //发送一个语句的类站长教学网 eduyo.com
    $rs->open($sql,$conn,1,3);          //打开连接的数据库
   
    $i = 0;
    ?>
    <table>
   
    <?php
    while(!$rs->eof)
    {
 
     $fields=$rs->fields(id);$id = $fields->value;
     $fields=$rs->fields(name);$name = $fields->value;
     $fields=$rs->fields(dizhi);$wangzhi = $fields->value;
     $fields=$rs->fields(see);$see = $see->value;
     $fields=$rs->fields(vip);$vip = $fields->value;
   
     $conn_q=mysql_connect("localhost","root","root") or die("1.未连接成功服务器！");
     mysql_select_db("wangzhi",$conn_q) or die("2.未连接成功数据库！");
     mysql_query("set names gb2312") or die("汉字编码出错");
     mysql_query("insert into caigou (name,wangzhi,see,vip)values('$name','$wangzhi','$see','$vip')") or die("3.添加未成功！".$mysql_error);
// $sql=mysql_query("insert into tb_affiche(title,content,createtime)values('$title','$content','$createtime')");

     
      
     if($i%6 == 0){
     echo "<tr>";
   };
   ?><td><?php echo $id;?>
   <a href="<?php echo $dizhi;?>" target="_blank"><?php
   if($vip < 3 and $vip !=""){echo "<b>";}
   echo $name;
   if($vip < 3 and $vip !=""){echo "</b>";}
   ?></a>
       </td>
   <?php
      $rs->movenext;
      if($i % 6 == 5){
       echo "</tr>";
     }
     if($i % 30 == 29){
       echo "<tr height='12px' bgcolor='#00CC00'><td ></td><td></td><td></td><td></td><td></td><td></td></tr>";
      }
      $i ;
    }
   ?></table>