ä»mysqlæ°æ®åºè¡¨ä¸éæºè·åæ°æ®
å
¶å®ï¼ä»æ°æ®åºéæºè·åæ°æ®ï¼å¾ç®åï¼åªé¡»ç¨å°ä¸ä¸ªrand()å½æ°;
select * from table_name
order by rand() limit 0,5;
ä¸é¢æ¯ä¸ä¸ªå°å®ä¾ï¼
ä»æç« è¡¨ä¸éæºè·å5æ¡æ°æ®ã
$dblink=mysql_connect("localhost","root","123456");
mysql_query("set names utf8");
mysql_select_db("aixuexi");
$sql="select * from waxx_article order by rand() limit 0,5";
$rs=mysql_query($sql);
while($row=mysql_fetch_array($rs)){
$rows[]=$row;
}
if($rows){
foreach($rows as $v){
?>
<div style="width:350px;height:35px;line-height:35px;border:1px solid #ccc;"><?php echo $v['title']; ?></div>
<?php
}
}else{
echo "ææ æç« ";
}