xyn Posted October 22, 2006 Share Posted October 22, 2006 Hey guys,This sounds quite stupid, but i'm wondering how to randomlypick 2 results from a database, and show them on my homepage, basically for my clients I am allowing them to leave amessage and stating what they like etc. then I was going torandomly pick 2 of the X amount and show them on my homepage.Any ideas? Link to comment Share on other sites More sharing options...
extrovertive Posted October 22, 2006 Share Posted October 22, 2006 ORDER BY RAND()LIMIT 2 Link to comment Share on other sites More sharing options...
xyn Posted October 22, 2006 Author Share Posted October 22, 2006 thx. Link to comment Share on other sites More sharing options...
Recommended Posts