| Call images by date?
Hi!
I'm playing with my browseimages.php, to see if can call images by date.
Right now the display options allow you to specify a simple time interval (last day, last x days/weeks/months and beginning) that subtracts that amount of time from the current time, and queries the db for all images posted since then.
Example: select all images from db where dateline is greater than (now minus time_interval). So my quest and my question is, how can I query the db for all images posted in a particular date?
The dateline field is a unix timestamp. From what I can tell, I have to convert this timestamp (using strtotime) to a readable date like yyyymmdd in all rows, compare that with my desired date, and output the rows that match.
Is this it? Seems like the wrong approach to me...
|