Re: sort by date
| From: | Ignatius Reilly | Date: | Wed, 06 Nov 2002 15:29:10 +0000 |
| Subject: | Re: sort by date | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-23019@lists.php.net to get a copy of this message | ||
Good point.
"Tell me and I forget, show me and I remember, involve me and I understand"
Ignatius
____________________________________________
----- Original Message -----
From: "Snijders, Mark" <Mark.Snijders@atosorigin.com>
To: "'Marco Tabini'" <marcot@inicode.com>; "Terry Romine"
<eatrom@blazing-trails.com>
Cc: <php-db@lists.php.net>
Sent: Wednesday, November 06, 2002 4:22 PM
Subject: RE: [PHP-DB] sort by date
> why does everybody always gives the answers?? why not a hint, or where to
> search that they can learn something about it???
>
>
>
>
>
> -----Original Message-----
> From: Marco Tabini [mailto:marcot@inicode.com]
> Sent: woensdag 6 november 2002 16:08
> To: Terry Romine
> Cc: php-db@lists.php.net
> Subject: Re: [PHP-DB] sort by date
>
>
> Ok, going out on a limb here... have you tried something like
>
> select e.id, title, location, address, contact, category, event_time,
> urllink, descript, min(event_date) from eventTable e inner join
> dateTable d on e.id = d.id group by e.id
>
> ?
>
>
> Marco
>
> --
> ------------
> php|architect - The magazine for PHP Professionals
> The first monthly worldwide magazine dedicated to PHP programmer
>
> Come visit us at http://www.phparch.com!
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>