MySQL Query help

[dan744]

Hi all,

I'm trying to display results of a MySQL Query grouped together in different tables (HTML tables) on my page.

I have in my table a list of Airlines and certain routes they fly. On selecting an airport it can display routes from that airport grouped by airlines.

Now the GROUP BY command groups them together as I want, but I would like the page to display it so that each airline has its own table i.e For East Midlands you would have

bmibaby
Route 1
Route 2
etc

easyjet
Route 1
Route 2
etc

but with the easyjet routes being in a different HTML table to the bmibaby ones.

Hope you understand what I mean!
Any suggestions?

Thanks in Advance,

Dan

[Pig]

The easiest way would be to set up nested queries. You qualify the second query with the ID from the current row of the first query.

$result = mysql_query("SELECT * FROM airlines");
while( $row = msyql_fetch_array($result) )
     {
     echo("<table><tr><td>$row[airline_name]</td></tr>");
     $sub_result = mysql_query("SELECT * FROM airline_routes WHERE airline_routes_id='$row[airlines_id]'");
     while( $sub_row = mysql_fetch_array($sub_row) )
          {
          echo("<tr><td>$sub_row[whatever]</td></tr>");
          }
     echo("</table>");
     }

Hope that answers your questions and makes sense.

[dan744]

Makes sense and works a treat, thanks a lot!

🙂