[OpenBSD]

I select 10 random query form mysql products table when products is featured AND approved . so, now i need to show 10 random image from gallery table when productid of image gallery table Equal of id of products table ( 10 random result / approved / featured ) . my coded not worked ! and i see one blank images in images list gallery . how to fix this ? i think JOIN method is better. how to work my idea with JOIN method ? THANKS

i have this :

$sql = 'SELECT id FROM products WHERE approved = 1 AND badge = "B" ORDER BY RAND() LIMIT 10 ';
$result = $db->query ($sql);
$row = $db->fetcharray($result);
while ($row = $db->fetcharray($result))
{
$sql = 'SELECT id,productid FROM gallery WHERE productid = '.$row['id'].' ORDER BY RAND() LIMIT 1';

 // fetch data and print in <img> and <li> .......

}

[Duckington]

SELECT p.id, g.productid, g.id as galleryid
FROM products p 
INNER JOIN gallery g ON g.productid = p.id
WHERE p.approved = 1 AND p.badge = "B" 
ORDER BY RAND() 
LIMIT 10 

or summit like that.

[OpenBSD]

not worked for me !

[Duckington]

It's not exact, it's just roughly how you would do it. Have a play with it and see what you can do.