Table problemer
Mit script:if ($rs) {
$ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;
echo "<table>";
echo "<tr><th>Title</th><th>Year</th><th>Starring</th>
<th>Director</th><th>Company</th><th>Genre</th>
<tr>";
while (!$rs->EOF) {
echo "<tr>
<td>".$rs->fields["movie_title"]."</td>
<td>".$rs->fields["movie_year"]."</td>
<td>".$rs->fields["act_name"]."</td>
<td>".$rs->fields["dir_name"]."</td>
<td>".$rs->fields["com_name"]."</td>
<td>".$rs->fields["gen_name"]."</td>
</tr>";
$rs->MoveNext();
}
echo "</table>";
}
Mit Problem:
I kolonnen act_name kan der som i den eneste forekomme flere.
Sådan ser det ud nu:
Title Year Starring Director Company Genre
x 2000 mr.X mr.y Star Comedy
x 2000 mrs.Z mr.y Star Comedy
Sådan skal der se ud:
Title Year Starring Director Company Genre
x 2000 mr.X, mrs.Z mr.y Star Comedy
Hvad skal jeg gøre?
