sorry
typo error should be:
date('Y')
Foong
"Foong" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> hi,
>
> $start = mktime ( 0, 0, 0, 1, 1, date['Y']); // first day of this year
> $end = mktime ( 0, 0, 0, 12, 31, date['Y']); // last day of this year
>
> then select all record where timestamp >= $start and timestamp <= $end
>
> should do the job
> Hope this helps
>
> Foong
>
>
>
>
> "Charles Kline" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> > Okay cool.
> >
> > This leads me to another question. If I have stored the date as an
> > epoch then is there a way using PHP and MySQL to say find all the
> > records that have been added this YEAR (not last 365 days)?
> >
> > Thanks
> > Charles
> >
> >
> > On Friday, March 28, 2003, at 12:31 AM, Leo Spalteholz wrote:
> >
> > > On March 27, 2003 09:15 pm, Charles Kline wrote:
> > >> I am storing my dates as unix timestamp (epoch). Am I right in
> > >> assuming that if I need to add or subtract days from this it is
> > >> done in seconds?
> > >
> > > yes
> > >
> > >
> > > --
> > > PHP General Mailing List (http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> > >
> >
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
