listing rows from different DB tables on same HTML table

[Uva_Negra]

My issue is this:
I have a mysql table with sports events (date, type, event, location, comments) and a mysql table with music events with the exact same fields. I've separated them so that the tables are more manageable.

I want to do a search on both tables based on various criteria like, for example, from one date to another, and i want the results to appear in the same HTML table ordered by date. i.e. the sports events will be mixed with the music events.

Is there a mysql query that can take care of this without doing any type of join?

IF not...what is the best way to do it? I imagine it's by using arrays, but i'm not sure how to approach it.

Thanks much.

[bastien]

combine the tables and have an extra catergory set by a hidden var on the form....

it is all the same data, regardless of what separation you see in terms of entertainment (music v sports)...db design priciples tell us not to duplicate data anywhere in the interests of good DB design and management....

but the sql for your current design is

$sql="select sports., music. from musicEvents music, sportEvents sports where sports.eventdate = music.eventdate and sports.eventdate=$mydate"

where $mydate is input by the user

hth