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



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

Reply via email to