mercredi 15 août 2018

MySQL PHP Order by Random for a certain time?

For example, say if you wanted a random result every 10 minutes. Is there a way to achieve this with ORDER BY RAND()?

$fetch = mysqli_query($conn, "SELECT * FROM food JOIN food_images ON food.size = food_images.size ORDER BY RAND()"); 

I also am using a JOIN and worried if this might affect the answers. Thank you!




Aucun commentaire:

Enregistrer un commentaire