Мне нужны результаты более чем одного оператора выбора (с использованием Limit (x), отображаемого в таблице, созданной p ⇐ Php
-
Anonymous
Мне нужны результаты более чем одного оператора выбора (с использованием Limit (x), отображаемого в таблице, созданной p
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' order by Time Asc Limit 1" ; I would like to add more select statements. The idea is that by using Order bt Time ASC and Limit 1 for each select statement, the single table will display the fastest entry for each style, e.g. one entry for Freestyle, one entry for Backstroke etc.
$query2= "SELECT Distinct AgeGrp, Gender,Dist, Stroke, First, Family, Name, Year, Time, Event, Date FROM JLSSWIMMING1 WHERE Year = '7' and Stroke = 'Backstroke' order by Time Asc Limit 1" ; 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 ... -x-display
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' order by Time Asc Limit 1" ; I would like to add more select statements. The idea is that by using Order bt Time ASC and Limit 1 for each select statement, the single table will display the fastest entry for each style, e.g. one entry for Freestyle, one entry for Backstroke etc.
$query2= "SELECT Distinct AgeGrp, Gender,Dist, Stroke, First, Family, Name, Year, Time, Event, Date FROM JLSSWIMMING1 WHERE Year = '7' and Stroke = 'Backstroke' order by Time Asc Limit 1" ; 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 ... -x-display
