SELECT event.*, location.place, seminar.name, seminar.shortdescription, seminar.longdescription, seminar.keywords
FROM event, location, rel_location, rel_seminar, seminar
where (event.id = rel_location.event and rel_location.location = location.id)
and (event.id = rel_seminar.event and rel_seminar.seminar = seminar.id)
and event.display = 1
and event.eventdate > "2006-01-15"
order by indexorder asc, eventdate asc
Getting first two records in MySQL query
Moderator: General Moderators
Getting first two records in MySQL query
I have a select query that is returning many records and want only the first two records. How do I do this?
- Christopher
- Site Administrator
- Posts: 13596
- Joined: Wed Aug 25, 2004 7:54 pm
- Location: New York, NY, US