 |
 |
Find a programming school near you
php-db | 2002091
Date: 09/02/02
- Next message: victor: "[PHP-DB] RE: [PHP] help, array values echoed as Array on loop!"
- Previous message: David Balatero: "Re: [PHP-DB] Re: What's wrong with this code?"
- In reply to: andy: "[PHP-DB] gettin records from today, yesterday, etc."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi,
It would better and far easier to use PHP's date functions, specifically
getdate() and date().
Check out the documentation here:
http://www.php.net/manual/en/function.getdate.php
HTH,
Jed
On the threshold of genius, andy wrote:
> Hi there,
>
> I am wondering how to get recors out of a mysql db from yesterday, last week
> and last month. I did write a small php hack but this does not work
> properly.
>
> I did this:
>
> ###################################################
> switch ($ts){
> case 1: // today
> $timestamp = substr($timestamp,0,8).'000000';
> break;
> case 2: // yesterday
> $timestamp = (substr($timestamp,0,8)-1).'000000';
> break;
> case 3: // last week
> $timestamp = (substr($timestamp,0,8)-7).'000000';
> break;
> };
> $start_date = $timestamp;
> $display_option = "AND p.timestamp > '$start_date'";
> ###################################################
>
> But it leads to problems if I search for last week since I do a siple
> subtraction of integer values and not of real days.
>
> Maybe some of you guys has a better appoach?
>
> Thanx,
>
> Andy
>
>
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
- Next message: victor: "[PHP-DB] RE: [PHP] help, array values echoed as Array on loop!"
- Previous message: David Balatero: "Re: [PHP-DB] Re: What's wrong with this code?"
- In reply to: andy: "[PHP-DB] gettin records from today, yesterday, etc."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
