我正在尝试从mysql数据库中获取random记录,这是有效的,但我需要记录也是unique,当我获取它们时,因为它们在输出中重复,这是我的代码:
<?
for ($counter = 1; $counter <=5;$counter++)
{
$randomPostSelect = mysql_query("SELECT DISTINCT * FROM beventreservation WHERE (beventStatus='online' OR beventStatus='soldout') ORDER BY RAND() LIMIT 5") or die(mysql_error());
$fetchPosts = mysql_fetch_array($randomPostSelect) or die(mysql_error());
echo '<li><a href="reservation.php?rev='.$fetchPosts['eventId'].'">'.$fetchPosts['eventTitle'].'</a></li>';
echo '</br>';
}
?>我该怎么做呢?
发布于 2012-05-09 22:45:46
您有一个for循环中的所有代码,包括运行查询的代码;您从db“提取”5行,但只提取第一行,并重复此操作5次。相反,您应该运行一次查询,然后循环结果,直到到达results的末尾
<?
$randomPostSelect = mysql_query("SELECT DISTINCT * FROM beventreservation
WHERE (beventStatus='online' OR beventStatus='soldout') ORDER BY RAND() LIMIT 5")
or die(mysql_error());
while ($fetchPosts = mysql_fetch_array($randomPostSelect))
{
echo '<li><a href="reservation.php?rev='.$fetchPosts['eventId'].'">'.$fetchPosts['eventTitle']
.'</a </li>';
echo '</br>';
}
?>https://stackoverflow.com/questions/10518345
复制相似问题