Как заполнить сгенерированную php таблицу html двумя (или более) операторами выбора Mysql ⇐ Php
-
Гость
Как заполнить сгенерированную php таблицу html двумя (или более) операторами выбора Mysql
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
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
Мобильная версия