PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |
Old February 1st, 2005, 06:07 PM   #1 (permalink)
rbl
Senior Member
Verified Customer
 
Join Date: Aug 2003
Location: Portugal
Posts: 492
Send a message via AIM to rbl Send a message via MSN to rbl
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...
rbl is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ImageMagick compression function call ppostuser Photopost Pro How Do I...? 4 March 15th, 2005 01:39 PM
Call to undefined function: parse_bbcode qwk98gt Photopost Pro Installation & Upgrades 1 January 28th, 2005 02:46 PM
Call to undefined function dethfire Photopost Pro Installation & Upgrades 3 June 24th, 2004 08:26 PM


All times are GMT -5. The time now is 12:32 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0