I Need Help with Random Loop

Hi All,

I want this to show in random form

Demo:
http://www.allworldinstruments.com/detail.php?nod=1554

I want to show More Products in Random Form

Please help me to set the following query in Random From ORDER BY RAND()

$sql = "Select * from ".$tbl_2." where pshow = 'Yes'  AND mainid = ".$p_sid." AND subid <> ".$nod." order by ranking limit 8";

Code (markup):

Thanks

 

Dear. One Person has helped me

Thanks

that is code
$sql = "Select * from ".$tbl_2." where pshow = 'Yes' AND mainid = ".$p_sid." AND subid <> ".$nod." order by RAND() limit 8";


Please Close this thread

 

You need to Show them i Random form right
Just change your
order by ranking limit 8

to

order by RAND() limit 8

here the code looks like

 

Thanks roopajyothi