RE: [PHP-DB] sort by date
| From: | Snijders, Mark | Date: | Wed, 06 Nov 2002 15:22:26 +0000 |
| Subject: | RE: [PHP-DB] sort by date | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-23017@lists.php.net to get a copy of this message | ||
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!