Re: sort by date
| From: | Marco Tabini | Date: | Wed, 06 Nov 2002 15:08:10 +0000 |
| Subject: | Re: sort by date | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-23016@lists.php.net to get a copy of this message | ||
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!