Playlists Active SQL " Table Of The Day"?

[Spacegoogie]

Can someone provide me with a working SQL table of the day script?

I can not get any I find or ones I put together working right. Can get the random table to load but its not the same table as it should be for the whole day. I can not get the date part of the script right.

 

 

My SQL (not working, only loading one random table each time)

SELECT * FROM Games WHERE EMUID= '1'
LIMIT(1) ORDER BY RANDOM(".date("Ymd").")

 

 

 

 

 

Thanks for the help! 

 

 

 

[Spacegoogie]

Solved! I changed the 10 games to 1 and good to go. Thanks to @NailBuster

https://www.nailbuster.com/wikipinup/doku.php?id=random_list

 

im a happy camper lol. 

The script looks way different then anything I had lol.