Как заполнить сгенерированную php таблицу html двумя (или более) операторами выбора Mysql ⇐ Php

[Гость]

new to php and MYSQL,and would like some help, so please be gentle I have some code which populates a HTML table using php echo. The statement is:

$query= "SELECT Distinct AgeGrp, Gender,Dist, Stroke, First, Family, Name, Year, Time, Event, Date FROM JLSSWIMMING1 WHERE Year = '7' and Stroke = 'Freestyle'" ; I would like to add more select statements, then display the results in the same html table e.g.

$query2= "SELECT Distinct AgeGrp, Gender,Dist, Stroke, First, Family, Name, Year, Time, Event, Date FROM JLSSWIMMING1 WHERE Year = '7' and Stroke = 'Backstroke'" ; Thanks in advance

From research it look like I may need an array, (not a join), but I am struggling at this point. Here is my current code:


Источник: https://stackoverflow.com/questions/780 ... lect-state