<?php
$sql5="select name from link";
$result5=mysql_query($sql5);
$rs5=mysql_fetch_array($result5);
$sql6="select url from link";
$result6=mysql_query($sql6);
while($rs6=mysql_fetch_array($result6)){
?>
<option value="<?php echo"$rs6[0]"?>"><?php echo "$rs5[0]"; ?></option>
<option value="<?php echo"$rs6[1]"?>"><?php echo "$rs5[1]"; ?></option>
<?php
}
?>
这个函数是要放在循环里的
$sql5="select name from link";
$result5=mysql_query($sql5);
$rs5=mysql_fetch_array($result5);
$sql6="select url from link";
$result6=mysql_query($sql6);
while($rs6=mysql_fetch_array($result6)){
?>
<option value="<?php echo"$rs6[0]"?>"><?php echo "$rs5[0]"; ?></option>
<option value="<?php echo"$rs6[1]"?>"><?php echo "$rs5[1]"; ?></option>
<?php
}
?>
这个函数是要放在循环里的
<?php
$sql6="select name,url from link";
$result6=mysql_query($sql6);
while($rs6=mysql_fetch_array($result6)){
?>
<option value="<?php echo"$rs6[name]"?>"><?php echo "$rs5[url]"; ?></option>
<?php
}
?>
都是同一个表,只要一个SQL语句就可。
你试试下面代码:
------------------------------------------------------------------------
mysql_connect("localhost", "用户名", "密码") or die("Could not connect: " . mysql_error());
mysql_select_db("表名");
$sql6="select name from link
$result6 = mysql_query($sql6);
$rs6 = mysql_fetch_array($result6, MYSQL_NUM);
echo "<PRE>";
print_r($rs6);
echo "</PRE>";
mysql_free_result($result6);
------------------------------------------------------------------------
while($rs6=mysql_fetch_array($result6){
.........................
}
to:乐言,您的代码我试过,无法正常显示,对不起,我不明白为什么,谢谢:)
to: rardge(Rardge),您的解释很好,茅塞顿开啦!让我明白为什么要用循环,谢谢:)
to:蓝狐狸、Creator~羽翼,二位的解释很简明,让我明白该怎么做就好,谢谢你们:)
呵呵,再次谢谢各位,十分感谢哦:)