Need Help Please

olygolfer

Can someone help me i am trying to use the random function to echo 3 random rows from the code below. The problem is I have no idea how to implement it correctly.

$_GET['cat'];
echo $cat;
$db = mysql_connect (, , );
mysql_select_db ('db76275624');
$query = "Select products.product, products.price ,products.productnumber, products.rewardpoints, products.shortdes, productdetails.largeimage, productdetails.product from products, productdetails where products.catagorie = '".$cat."' and products.catagoriefeatured = 'yes' and products.product = productdetails.product"; 
$result = mysql_query($query, $db);
while ($myrow = mysql_fetch_array($result))
{
echo "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">";
echo "<tr>";

Can someone point me in the right direction and show me where to insert it.

khaldryck

check about the rand() function in the mysql documentation.
i read there that we can use it to order the table on rand, and so
if you exit the loop when you've got your 3 rows, it should work.

there is another way, but it's just a patchy solution using your query once to know the ids, get 3 random from there, then select
again using where id in() <- put the 3 ids in there ...
not very good ...