select random unique records from mysql db using php

Question

i am trying to fetch random records from mysql database , which it worked but i need the records to be also unique when i fetch them as they duplicated on the output, here is my code:

    <?

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>';
}


?>

how can i do that ?

Write your sql query outside the for loop

user1432124
– user1432124

2012-05-09 14:44:14 +00:00
Commented May 9, 2012 at 14:44 — user1432124
– user1432124, Commented May 9, 2012 at 14:44

Nadir Sampaoli · Accepted Answer · 2012-05-09 14:45:45Z

2

You have all the code in a for loop including the code that runs the query; you "extract" 5 rows from db but only fetch the first, and repeat this 5 times. Instead you should run the query once, then loop on your results until you reach the end of the 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>';
}
?>

answered May 9, 2012 at 14:45

Nadir Sampaoli

5,5654 gold badges24 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Bader H Al Rayyes Over a year ago

thanks :) , i just figure out that before 10 seconds :) , thank you for your time .

Collectives™ on Stack Overflow

select random unique records from mysql db using php

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related