why does everybody always gives the answers?? why not a hint, or where to
search that they can learn something about it???
From: Marco Tabini [mailto:marcot@;inicode.com]
Sent: woensdag 6 november 2002 16:08
To: Terry Romine
Cc: [EMAIL PROTECTED]
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