[PHP] Unix Timestamp

[Delici0us]

Hi!

Up until recently I’d never touched Unix Timestamps and for some reason I decided it was about time to move on, and I have.

The problem is I am caught in a slight corner, I converted most of the code from D-M-Y to time() but now, how do I search the database by the Unix timestamp and define a month, without being too hard on resources?

Any help would be appreciated.

 

[jMerliN]

Calculate timestamp for beginning of month and for end of month, and do a search on the time field where it's between those two.

 

[Delici0us]

Thanks, I never thought of that!