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!
--- Begin Message ---
I have two tables, one contains event information and the other dates
that the event takes place:
| id | int(11) | | PRI | 0 | auto_increment |
| title | varchar(100) | YES | | NULL | |
| location | varchar(100) | YES | | NULL | |
| address | varchar(100) | YES | | NULL | |
| contact | varchar(100) | YES | | NULL | |
| category | varchar(100) | YES | | NULL | |
| event_time | varchar(200) | YES | | NULL | |
| urllink | varchar(100) | YES | | NULL | |
| descript | text | YES | | NULL | |
| id | int(11) | | PRI | 0 | auto_increment |
| event_key | int(11) | YES | | NULL | |
| event_date | date | YES | | NULL | |
They are linked via dateTable.event_key=eventTable.id
I want to be able to sort by the first date that the event takes place.
I tried:
$sql="select e.*,d.event_date from eventTable e,dateTable d where
e.id=d.event_key order by d.event_date,d.event_key
but it still shows each date that the event takes place. I tried doing
a min(d.event_date) as event_date and then "group by" instead of "order
by" but still get too many results.
Any help to straighten this out?
Terry
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
