PHP fórum

Caute, mam problem s vyberom dat z tychto 3 tabuliek:

• exc-list of excercises
• res-results list of excercises
• usr-users list

Z tychto tabuliek by som rad vybral vsetky ulohy priradene danemu datumu v tomto fotmate:

• Janko Mrkvicka
• 1st June 2009
• odcitanie 78%
• scitanie 80%
• 31st May 2009
• odcitanie 100%
• sciatnie 100%

Avsak moj dopyt mi to vypise v tomto formate:

• Janko Mrkvicka
• 1st June 2009
• odcitanie 78%
• 1st June 2009
• scitanie 80%
• 31st May 2009
• odcitanie 100%
• 31st May 2009
• scitanie 100%

Moj dopyt vyzera asi takto:

<?php
$query1="SELECT DATE_FORMAT(res_time, '%D %M %Y') AS res_time, exc_excercise_name, res_result FROM res, exc
WHERE res_usr_id=$_GET[id] AND res_exc_id=exc_id GROUP BY DATE_FORMAT(res_time, '%D %M %Y'),
exc_excercise_name HAVING COUNT(DATE_FORMAT(res_time, '%D %M %Y')) = 1";
        $result1 = mysql_query($query1);
        while (list($res_time,$exc_excercise_name,$res_result) = mysql_fetch_row($result1)) {
        echo "<tr>",
                "<td class='time'>",
                        $res_time,"</td>",
                        "</tr>",
                        "<tr>",
                        "<td>",
                        "</td>",
                "<td class='font'>",
            $exc_excercise_name,"</td>",
            "<td>",
            "</td>",
                        "<td>",
            "</td>",
            "<td class='result'>",
            $res_result,"%","</td>",
        "</tr>";
}
@mysql_close($connect);
                        ?>