Vypis udajov z db – MySQL – Fórum – Programujte.com

Zdravim mam takyto dotaz do db
$result5 = mysql_query("SELECT tp_id, line, name, project FROM line, position WHERE position.dbref = line.dbref ORDER BY project, line, name ASC");

a jeho vysledok je
XBOX360 A BOOKIN 1
XBOX360 A BOOKIN 2
XBOX360 A BOOKIN 3
XBOX360 A BOOKIN 4
XBOX360 A BOOKOUT 7
XBOX360 A BOOKOUT 8
XBOX360 A BOOKOUT 9
XBOX360 A BOOKOUT 10
XBOX360 A BOOKOUT 5
XBOX360 A BOOKOUT 6
XBOX360 A GAME-TEST 11
XBOX360 A GAME-TEST 12

da sa nejako upravit dotaz tak aby my vypisal len 1x prve 3 riadky a potom do riadku by vypisal cisla v podstate aby to vypadalo takto
A BOOKIN XBOX360 1 2 3 4
A BOOKOUT XBOX360 7 8 9 10 5 6
A GAME-TEST XBOX360 11 12

vopred diky

este pripajam struktur db
position:
dbref line name project
1 A BOOKIN XBOX360
2 A BOOKOUT XBOX360
3 A GAME-TEST XBOX360
line:
id dbref tp_id
1 1 1
2 1 2
3 1 3
4 1 4
5 2 5
6 2 6
7 2 7
8 2 8
9 2 9
10 2 10
11 3 11
12 3 12

Nakoniec som to vyriesil takto:

$result5 = mysql_query("SELECT dbref, line, name, project FROM position ORDER BY project, line, name ASC");
echo "<table border='1' style='position: absolute; left: 400px; top: 80px;'><tr style='vertical-align:top'>";
while ($row5 = mysql_fetch_array($result5))
{
echo "<tr><td>".$row5["project"]."</td><td>".$row5["line"]."</td><td>".$row5["name"]."</td><td>".$row5["tp_id"]."</td>";
$result6 = mysql_query("SELECT tp_id FROM line where dbref='".$row5['dbref']."'");
while ($row6 = mysql_fetch_array($result6))
{
echo "<td>".$row6['tp_id']."</td>";
}
echo "</tr>";
}
echo "</table>";

neviem ci je to najefektivnejsie ale facha to super