Problems with my fixture list array...

rugbylad123

Hi everyone, I've managed to create a 'randomizing' fixture list which outputs the following result :

Array ( [0] => Array ( [0] => ARFC vs FRFC [1] => BRFC vs ERFC [2] => CRFC vs DRFC ) [1] => Array ( [0] => ARFC vs BRFC [1] => CRFC vs FRFC [2] => DRFC vs ERFC ) [2] => Array ( [0] => ARFC vs CRFC [1] => DRFC vs BRFC [2] => ERFC vs FRFC ) [3] => Array ( [0] => ARFC vs DRFC [1] => ERFC vs CRFC [2] => FRFC vs BRFC ) [4] => Array ( [0] => ARFC vs ERFC [1] => FRFC vs DRFC [2] => BRFC vs CRFC ) )

Obviously it's an array within an array but I was actually attempting to output it in the format of :

Matchday 1
 A v F
 B v E
 C v D
Matchday 2
...
etc.

My code for my output is:

 $host="localhost";  // Host name
     $username="root";   // Mysql username
     $password="";       // Mysql password
     $db_name="rugby"; // Database name
     $connect = mysql_connect(localhost,root,$password)or die("Can't Connect");
     mysql_select_db($db_name,$connect)or die("Can't Select Database");

 //Make TeamID an array which can be accessed to generate fixtures by randomizing.
 $teamid = array('ARFC','BRFC','CRFC','DRFC','ERFC','FRFC');
 // this array will be associated with the database.
 $fixtures= array();
 $TeamIDCount = sizeof($teamid);
 $ListofTeamID = array_keys($teamid);
 $TemporaryList = array_splice($ListofTeamID,1,sizeof($ListofTeamID)-1);
 $count = sizeof($TemporaryList) + 1;

 for ($i = 0;$i < $TeamIDCount - 1;$i++)
  {
   $fixtures[$i] = array();
   $fixtures_list = array_merge(array($ListofTeamID[0]), $TemporaryList);
   for ($j = 0;$j < $count / 2;$j++)
    {
     $fixtures[$i][] = $teamid[$fixtures_list[$j]] . ' vs ' . $teamid[$fixtures_list[$count - $j - 1]];
    }
    // 'Randomises the List
    $random = array_shift($TemporaryList);
    array_push($TemporaryList, $random);
}
 print_r($fixtures);
}

Thanks for reading, and I hope you can help me out.
As my next step would be to allow a user to input scores for each fixture using HTML input commands. This would then update my league table.

rugbylad123

I have changed the :

 print_r($fixture;

to :

 echo '<pre>'.print_r($fixtures, true).'</pre>';

which outputs it like i would like, However I would like to change the names of:

Array
(
    [0] => Array
        (
            [0] => ARFC vs FRFC
            [1] => BRFC vs ERFC
            [2] => CRFC vs DRFC
        )

[1] => Array
    (
        [0] => ARFC vs BRFC
        [1] => CRFC vs FRFC
        [2] => DRFC vs ERFC
    )

[2] => Array
    (
        [0] => ARFC vs CRFC
        [1] => DRFC vs BRFC
        [2] => ERFC vs FRFC
    )

[3] => Array
    (
        [0] => ARFC vs DRFC
        [1] => ERFC vs CRFC
        [2] => FRFC vs BRFC
    )

[4] => Array
    (
        [0] => ARFC vs ERFC
        [1] => FRFC vs DRFC
        [2] => BRFC vs CRFC
    )

)

the array to output as :
Fixture List
Matchday1
..
..
..
Matchday 2

bradgrafelman

[man]print_r/man is really only meant for debugging purposes.

What you'll want to do is use a loop within a loop. For example, I would use two [man]foreach/man loops; the outer loop would loop through each 'Matchday' and the inner loop would loop through each "match" for a given 'matchday.'

EDIT: It's essentially the same as the double for() loop you've got above; you're just outputting elements rather than creating them.

rugbylad123

Thanks alot buddy for the feedback, are you meaning something similar to this:

echo '<table><thead><tr><th class="idx">Row</th>'; //outputs the table of results
        for ( $i = 0 ; $i < mysql_num_fields($result) ; $i++ )
         {
         echo "<th>" . mysql_field_name($result,$i) . "</th>\n";
         }
        echo "</tr></thead>\n<tbody>";
        for ( $i = 0 ; $i < mysql_num_rows($result) ; $i++ )
         {
          echo '<tr><td class="idx">' . ($i + 1) . '</td>';
          $row = mysql_fetch_row($result);
          for ( $j = 0 ; $j < mysql_num_fields($result) ; $j++ )
           {
            echo '<td>' . $row[$j] . '</td>';
           }
          echo "</tr>\n";
         }
        echo '</tbody></table>';

bradgrafelman

I suppose that code is "similar" in the sense that it contains a loop within another loop, but that's pretty much where the similarities end, since you a) would be better off using foreach() loops instead, and b) won't need any mysql_*() function (both because the entire mysql extension has been deprecated and because you're operating on an array now rather than a DB result set).

rugbylad123

ah right I think I get what you mean. To be brutally honest I've only just started using PHP and MySQL the last 5 months and I have never used the Foreach loop function. I've read the link you sent as well, brain seems to be on meltdown mode.
Thanks for your help, if I get stuck again I'll post again.