Databases
StackOverflow2013
Postsdbo
POcreate a dynamic php/html table with mysql specific value in <td> ("League"-System)
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POcreate a dynamic php/html table with mysql specific value in <td> ("League"-System)
    text
    copied!<p>i struggle with the following structure / logic... the project is about how to build a league on php &amp; mysql every player has to play against each other</p> <p>i want to generate a (dynamic) table like this one:</p> <pre><code>&lt;table border="1"&gt; &lt;tr&gt; &lt;td&gt;--&lt;/td&gt; &lt;td&gt;1&lt;/td&gt; &lt;td&gt;2&lt;/td&gt; &lt;td&gt;3&lt;/td&gt; &lt;td&gt;4&lt;/td&gt; &lt;td&gt;5&lt;/td&gt; &lt;td&gt;6&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;1&lt;/td&gt; &lt;td&gt;--&lt;/td&gt; &lt;td&gt;x&lt;/td&gt; &lt;td&gt;x&lt;/td&gt; &lt;td&gt;x&lt;/td&gt; &lt;td&gt;x&lt;/td&gt; &lt;td&gt;x&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;2&lt;/td&gt; &lt;td&gt;--&lt;/td&gt; &lt;td&gt;--&lt;/td&gt; &lt;td&gt;x&lt;/td&gt; &lt;td&gt;x&lt;/td&gt; &lt;td&gt;x&lt;/td&gt; &lt;td&gt;x&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;3&lt;/td&gt; &lt;td&gt;--&lt;/td&gt; &lt;td&gt;--&lt;/td&gt; &lt;td&gt;--&lt;/td&gt; &lt;td&gt;x&lt;/td&gt; &lt;td&gt;x&lt;/td&gt; &lt;td&gt;x&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;4&lt;/td&gt; &lt;td&gt;--&lt;/td&gt; &lt;td&gt;--&lt;/td&gt; &lt;td&gt;--&lt;/td&gt; &lt;td&gt;--&lt;/td&gt; &lt;td&gt;x&lt;/td&gt; &lt;td&gt;x&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;5&lt;/td&gt; &lt;td&gt;--&lt;/td&gt; &lt;td&gt;--&lt;/td&gt; &lt;td&gt;--&lt;/td&gt; &lt;td&gt;--&lt;/td&gt; &lt;td&gt;--&lt;/td&gt; &lt;td&gt;x&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;6&lt;/td&gt; &lt;td&gt;--&lt;/td&gt; &lt;td&gt;--&lt;/td&gt; &lt;td&gt;--&lt;/td&gt; &lt;td&gt;--&lt;/td&gt; &lt;td&gt;--&lt;/td&gt; &lt;td&gt;--&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; </code></pre> <p>Each number is a nickname, so this ends up how to display the stats</p> <p>And now my stuff so far:</p> <pre><code> $get_player = mysql_query("SELECT nickname, id FROM player"); $get_player_score = mysql_query("select player_id, game1, game2, game3 from 1on1_matches_scores where 1on1_matches_id = (select id from 1on1_matches where league_id = (select id from league where league_type_id = (select id from league_type where id = 1) and season_id = (select id from season where id = 1)) limit 1)"); while ($row = mysql_fetch_array($get_player)) $results[$row[nickname]][] = $row[id]; while ($row = mysql_fetch_array($get_player_score)) $data[$row[player_id]][] = $row[game3]; echo "&lt;table border='1'&gt;&lt;tr&gt;"; echo "&lt;td&gt;--&lt;/td&gt;"; foreach ($results as $key =&gt; $value) echo "&lt;td&gt;$key&lt;/td&gt;"; echo "&lt;/tr&gt;"; foreach ($results as $key =&gt; $value) { echo "&lt;tr&gt;&lt;td&gt;$key&lt;/td&gt;"; foreach ($data as $key =&gt; $value) : foreach ($value as $cell_value) echo "&lt;td&gt;Punkte: $cell_value&lt;/td&gt;"; endforeach; echo "&lt;/tr&gt;"; } </code></pre> <p>Alright, how do i get a specific value (the result of a match) into the exact td from player 1 and player 2?</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload