[thelist] Displaying info according to date

[Paul Bennett]

Andre Genic wrote:

>Hi boys and girls, I've been trying to work on something, basically cos I
>don't know how to do it, so I thought a few days of messing around might
>lead to something productive, alas it didn't.
>
>What I'm trying to do, is add information to a table and then retrieve
>everything up to a date point, I've tried a few things like using $now =
>$date and using a formatted date in the sql query, but no luck, I'm storing
>dates like this $date = date("M jS Y"); you probably get the idea.
>  
>
Andre, I had a similar conundrum a few moons ago and found to my joy the 
strtotime() function which takes a date and converts it into the number 
of seconds since Jan 01 1970. Basically if you use this for time related 
apps, it gives you an exact (to the second) benchmark against which you 
can select and compare timed entries. Then your sql may be:
"SELECT * from $table where timestamp >= '$my_first_timestamp' and 
timestamp <= '$my_last_timestamp'";
This would give you the range of entries between 2 times

>
>  
>


-- 
 ------------------------------
	Paul Bennett						
	Internet Developer				
	Teltest Electronic Design		
 ------------------------------			
Email: paul at teltest.com				
Phone: 64 4 237 4557					
Web: http://www.teltest.com		
Wap: http://wap.teltest.com