Auf Thema antworten 2026

Beitrag

<blockquote data-quote="Blackout289" data-source="post: 1504008" data-attributes="member: 352471">Hallo Leute,habe mir hier eine Mysql Abfrage gebastelt. Jedoch würde ich diese gern optimieren. Also mit Joins usw. Jedoch weiß ich noch nicht wirklich wie ich das hier machen kann.kann mir evtl jmd helfen oder einen Tipp geben?[php]$getnick= mysql_query(&quot;SELECT id FROM ts_user WHERE nick = &#039;$nick&#039;&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while($row = mysql_fetch_object($getnick))&nbsp; &nbsp; &nbsp; &nbsp; {$userid = $row-&gt;id;&nbsp; &nbsp; $getpoints= &quot;SELECT SUM(`points`) FROM ts_tipps WHERE `uid` = &#039;$userid&#039;&quot;;&nbsp; &nbsp; $getpoints1 = mysql_query($getpoints);&nbsp; &nbsp; &nbsp; &nbsp; while ($summe = mysql_fetch_array($getpoints1)) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $userpunkteall = $summe[0]; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &#039;&lt;table id=&quot;spielplan3&quot; cellspacing=&quot;11&quot;&gt;&lt;thead&gt;&lt;tr&gt;&lt;th&gt;ID&lt;/th&gt;&lt;th&gt;Anstoss&lt;/th&gt;&lt;th&gt;Spiel&lt;/th&gt;&lt;th&gt;Dein Tipp&lt;/th&gt;&lt;th&gt;Das Ergebnis&lt;/th&gt;&lt;th&gt;Punkte &#039;.$userpunkteall.&#039;&lt;/th&gt;&lt;/tr&gt;&lt;/thead&gt;&lt;tbody&gt;&#039;;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; $getnick2= mysql_query(&quot;SELECT * FROM ts_spiele&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while($row2 = mysql_fetch_object($getnick2))&nbsp; &nbsp; &nbsp; &nbsp; {$gameid2 = $row2-&gt;id;$heimid = $row2-&gt;heim;&nbsp;$gastid = $row2-&gt;gast;&nbsp; &nbsp; $gamestart = $row2-&gt;gamestart;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $getnick3= mysql_query(&quot;SELECT team FROM ts_teams WHERE id = $heimid&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while($row3 = mysql_fetch_object($getnick3))&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $heim = $row3-&gt;team;&nbsp; &nbsp; $getnick4= mysql_query(&quot;SELECT team FROM ts_teams WHERE id = $gastid&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while($row4 = mysql_fetch_object($getnick4))&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $gast = $row4-&gt;team;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $getnick5= mysql_query(&quot;SELECT heim, gast, points FROM ts_tipps WHERE uid = &#039;$userid&#039; AND gid = $gameid2&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while($row5 = mysql_fetch_object($getnick5))&nbsp; &nbsp; {&nbsp;$heimt = $row5-&gt;heim;$gastt = $row5-&gt;gast;&nbsp;$userpunkte = $row5-&gt;points;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $getnick6= mysql_query(&quot;SELECT heim, gast FROM ts_ergeb WHERE gid = $gameid2&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while($row6 = mysql_fetch_object($getnick6))&nbsp; &nbsp; {&nbsp;$heime = $row6-&gt;heim;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $gaste = $row6-&gt;gast;[/php]Dankeschön Black</blockquote>

[QUOTE="Blackout289, post: 1504008, member: 352471"] Hallo Leute, habe mir hier eine Mysql Abfrage gebastelt. Jedoch würde ich diese gern optimieren. Also mit Joins usw. Jedoch weiß ich noch nicht wirklich wie ich das hier machen kann. kann mir evtl jmd helfen oder einen Tipp geben? [php]$getnick= mysql_query("SELECT id FROM ts_user WHERE nick = '$nick'"); while($row = mysql_fetch_object($getnick)) { $userid = $row->id; $getpoints= "SELECT SUM(`points`) FROM ts_tipps WHERE `uid` = '$userid'"; $getpoints1 = mysql_query($getpoints); while ($summe = mysql_fetch_array($getpoints1)) { $userpunkteall = $summe[0]; echo ' <table id="spielplan3" cellspacing="11"> <thead> <tr> <th>ID</th> <th>Anstoss</th> <th>Spiel</th> <th>Dein Tipp</th> <th>Das Ergebnis</th> <th>Punkte '.$userpunkteall.'</th> </tr> </thead> <tbody>'; } $getnick2= mysql_query("SELECT * FROM ts_spiele"); while($row2 = mysql_fetch_object($getnick2)) { $gameid2 = $row2->id; $heimid = $row2->heim; $gastid = $row2->gast; $gamestart = $row2->gamestart; $getnick3= mysql_query("SELECT team FROM ts_teams WHERE id = $heimid"); while($row3 = mysql_fetch_object($getnick3)) { $heim = $row3->team; $getnick4= mysql_query("SELECT team FROM ts_teams WHERE id = $gastid"); while($row4 = mysql_fetch_object($getnick4)) { $gast = $row4->team; $getnick5= mysql_query("SELECT heim, gast, points FROM ts_tipps WHERE uid = '$userid' AND gid = $gameid2"); while($row5 = mysql_fetch_object($getnick5)) { $heimt = $row5->heim; $gastt = $row5->gast; $userpunkte = $row5->points; } $getnick6= mysql_query("SELECT heim, gast FROM ts_ergeb WHERE gid = $gameid2"); while($row6 = mysql_fetch_object($getnick6)) { $heime = $row6->heim; $gaste = $row6->gast; [/php]Dankeschön Black [/QUOTE]

Bilder bitte hier hochladen und danach über das Bild-Icon (Direktlink vorher kopieren) platzieren.

Authentifizierung

Wenn ▲ = 5, ▼ = 2 und ■ = 7, was ist ▲ × ▼ + ■?