Hello
I Need To Know how to
Retrieve Random Data From A Table In Database
i have a table called actiongames
i need a code to retrieve random data from this table
-==Zero==-
-3
Junior Poster
Recommended Answers
Jump to PostZero, for something like this, you'll start learning MySQL Operators.
SELECT * FROM actiongames ORDER BY RAND()If you want to designate how many rows to gather
SELECT * FROM actiongames ORDER BY RAND() Limit 5Hope this helps!
All 4 Replies
stoopkid
6
Junior Poster in Training
Zero, for something like this, you'll start learning MySQL Operators.
SELECT * FROM actiongames ORDER BY RAND()If you want to designate how many rows to gather
SELECT * FROM actiongames ORDER BY RAND() Limit 5Hope this helps!
-==Zero==-
commented:
Thanks Mate :)
+2
-==Zero==-
-3
Junior Poster
Zero, for something like this, you'll start learning MySQL Operators.
SELECT * FROM actiongames ORDER BY RAND()If you want to designate how many rows to gather
SELECT * FROM actiongames ORDER BY RAND() Limit 5Hope this helps!
Ya It helps so much thanks so much
stoopkid
6
Junior Poster in Training
Please mark as "Solved" =)
-==Zero==-
-3
Junior Poster
Sure Solved Thanks So Much
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.