打印

html中select语句读取mysql表中内容

html中select语句读取mysql表中内容

<?
  $record=0;
  $db=@mysql_pconnect('localhost','root');
  @mysql_select_db('1234',$db);
  $strsql="select * from 1234_data";
  $result=@mysql_query($strsql);
  $data=@mysql_fetch_array($result);
  $record=@mysql_num_rows($result);

  echo "<select name=type size=1>\n";
       do{
             if ($record==1){
                echo "<option value=".$data['cname']." selected>".$data['cname']."</option>\n";
                          }
             else{
                echo "<option value=".$data['cname'].">".$data'cname']."</option>\n";
             }
       }while($data=@mysql_fetch_array($result));
       echo "</select>\n";
?>

TOP

当前时区 GMT-4, 现在时间是 2008-10-12 18:11
ComePlay8.Com
Powered by Discuz! 6.0.0 © 2001-2007 Comsenz Inc.
Processed in 0.167021 second(s), 10 queries, Gzip enabled
TOP
清除 Cookies - 联系我们 - 来玩吧 - Archiver - WAP
Designed By Discuz! Support Team