0

In my Database(mysql) i have 100 members registered,Now there is page i want to display only ten members, but after each page refresh i want other ten members to display at the very same place Meaning replacing the current shown members.
Any one with the idea on how i can Do this i will appreciate.
thankx

2
Contributors
2
Replies
3
Views
9 Years
Discussion Span
Last Post by mrcniceguy
1

This is fairly simple, use the RAND function in the SQL query:

$sql = "SELECT * FROM tablename WHERE somefield='something' ORDER BY RAND() LIMIT 10";
Votes + Comments
Nice Answer....
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.