AndrewFerrara Posted February 5, 2011 Share Posted February 5, 2011 I want to create an animation using an image that refreshes every hour hosted at this url: http://www.bungie.net/stats/reach/nightmap.ashx What is the best way to store the images and then animate(loop) the 24 most recent images? Should I use a mysql database to store it or something else? What are your thoughts? Thanks Quote Link to comment Share on other sites More sharing options...
fortnox007 Posted February 5, 2011 Share Posted February 5, 2011 well what i can think of is a database with a table named images where you store the file name of the uploaded images. every-time you upload an image a new row is made in the table. Than you make a little php script hat does a simple select query $query = "SELECT * FROM images LIMIT 0,23 DESC"; Does this help a little? edit: table could look like this image_ID + image_name + timeperhaps --------------------------------------------------------- 0 | lalala.jpg | xxxxxx Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.