mysql help

[acidglitter]

What's a better way to do this?

Right now I have this..

 

$shows_sql=mysql_query("SELECT
shows.*,
showbands.band_id
FROM shows
INNER JOIN showbands
ON shows.show_id = showbands.show_id
GROUP BY shows.show_id
ORDER BY shows.dated ASC");

 

When it shows the shows, it only shows the first band_id. I'm thinking I'm just going to have a 2nd query for the bands so it will show all of them. But the problem with that is it would take a lot longer to load. Is there a better way to do this?

[Barand]

What's a better way to do this?

 

 

To do what?

 

All you've given is code that does what you don't want.