[subuntug]

Hello;

I have a Multi-Dimensional Array from mysql table and need to display it as html table.

here is the variable holding my array data:

PHP Code:

  $students_marks = mysql_query("SELECT * FROM v_exam_marks);

        $num_marks = mysql_num_rows($students_marks);



        for($i=0; $i<$nbr_note; $i++)

        {

            $student = mysql_result($students_marks, $i, 'student');

            $module = mysql_result($students_marks, $i, 'module');

            $mark = mysql_result($students_marks, $i, 'mark');

                

   $myArray[$student][$i] = array($module, $mark);

                        

        } 

When I do

PHP Code:

 echo $student. "|". $module. "|". "$mark"."<br />"; 

I get:

cbota|B211|16.5
cbota|C305|16.5
cmolina|B211|6
cmolina|C305|3
cmolina|D318|12.22
ifattel|B211|6
ifattelC305|3
ifattel|D318|6.33
jdvaux|B211|8.88
jdvaux|C305|8.88
jdvaux|D318|9
jGary|D318|18
lRanni|D318|8


What I want it's to display my data in HTML table like this:

HTML Code:

<table>
<tr><th>&nbsp;</th><th>B211</th><th>C305</th><th>D318</th></tr>
<tr><th>cbota</th><td>16.5</td><td>16.5</td><td>&nbsp;</td></tr>
<tr><th>cmolina</th><td>6</td><td>3</td>12.22<td>&nbsp;</td></tr>
<tr><th>ifattel</th><td>6</td><td>3</td><td>6.33</td></tr>
<tr><th>jdvaux</th><td>8.88</td>&nbsp;<td>8.88</td><td>9</td></tr>
<tr><th>jGary</th><td>&nbsp;</td><td>&nbsp;</td><td>18</td></tr>
<tr><th>cbota</th><td>&nbsp;</td><td>&nbsp;</td><td>8</td></tr>
</table>

How can I do with php, to get this kind of HTML table from my data base query.

Thanks in advances for your help

[Jcbones]

Try this, and let me know how it goes: Un-Tested.

PHP Code:

$students_marks = mysql_query("SELECT * FROM v_exam_marks);

        $num_marks = mysql_num_rows($students_marks);

if($num_marks > 0) {

       while($r = mysql_fetch_assoc($student_marks))

        {         

         $modules[$r['student']][$r['module']] = $r['mark'];

        }



if(is_array($modules)) {

echo "<table>\n<tr>\n<th>&nbsp;</th>\n<th>B211</th>\n<th>C305</th>\n<th>D318</th>\n</tr>\n";

  foreach($modules as $k => $v) {

   echo '<tr><td>$k</td>

   echo (isset($modules[$k]['B211'])) ? '<td>' . $modules[$k]['B211'] . '</td>' : '<td>&nbsp;</td>';

  echo (isset($modules[$k]['C305'])) ? '<td>' . $modules[$k]['C305'] . '</td>' : '<td>&nbsp;</td>';

   echo (isset($modules[$k]['D318'])) ? '<td>' . $modules[$k]['D318'] . '</td>' : '<td>&nbsp;</td>';

  echo '</tr>';

 }

echo '</table>';         

}

} 

[subuntug]

Hello;

I tested it, and it works. Thank you very much.
But, still a problem, in the code you propose, the
modules are hard-coded. I need to take the name of the
modules from variables, because I have many other
modules in mysql table and they can change.

So, is there a way to catch the name of each module
directly from mysql table. For instance remove:

PHP Code:

$modules[$k]['B211'] 

and replace it with something like

PHP Code:

$modules[$k][$module] 

Thank you in advance for your precious help.