strtotime and dates

slimjim

Lets say I would like to show how many rows that are in a table for today and also show how many rows for 6 previous days...

I am using strtotime inserting like :

".strtotime(date("d M Y H:i:s"))."

Showing in table like :
( 1101045154 )

[id] [mdate]

mdate is where the time is being stored

Mordecai

You want to use [FONT=courier new]time()[/FONT], not [Font=courier new]strtotime(date())[/font].

Are you trying to pull from a MySQL database? If so, try using [font=courier new]BETWEEN[/font]. 6 days ago would be something like ($time-(606024*6)) (60 seconds in 60 minutes in 24 hours in 6 days).

Hope that can help.

devinemke

SELECT * FROM table WHERE mdate BETWEEN (UNIX_TIMESTAMP() - 518400) AND UNIX_TIMESTAMP()

slimjim

Ok first why not strtotime
Problem is that I have already beeing using it and do not want to change it.

SELECT * FROM table WHERE mdate BETWEEN (UNIX_TIMESTAMP() - 518400) AND UNIX_TIMESTAMP()

Now from this select, not sure IF I understand you on this.
You have :
UNIX_TIMESTAMP

In there twice and what actually is UNIX_TIMESTAMP, and why -518400 and from what ?

Can anyone give me an example using strtotime and how would I show them on a page ? New to this time stuff, I do not want to get confused from other times cause I am working with strtotime right now.

Mordecai

You don't want to use strtotime(date()) because it's a waste of time. Date() gives you a string from a timestamp, and strtotime() gives you a timestamp from a string. So, basically, it does nothing, but add another spot for potential error.

UNIX_TIMESTAMP() is a MySQL function. The way he uses it will work similar to PHP's [man]time/man function--it returns the current UNIX timestamp. You can also use it like [man]strtotime/man to change a string into a UNIX timestamp.

518400 is 606024*6, or the number of seconds in 6 days.

slimjim

OK but, I am using strtotime on many other things and it puts that format in.

IS there a way to get the results of 1101045154 from that table and then convert it into a UNIX_TIMESTAMP() and then use that select ?

Also how would i preview that info on a page using that select...

Sorry for the confusion.

Mordecai

That 1101045154 is already a UNIX timestamp, so you don't need to make it a timestamp again.
Also, I'm not sure what the latter part of that post is asking. Can you clarify, please?

slimjim

How do i display the results like, so if today is Mon :

Tues = 1
Wed = 0
Thur = 5
Fri = 3
Sat = 0
Sun = 1
Mon TODAY= 1

for today and previous 6 days