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
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.