Re: sort by date

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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:  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:  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
>
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux