<?
$sql = "SELECT *
FROM demobeschikbaar
WHERE boot='$zoekjacht'";
$res = mysql_query($sql) or die(mysql_error());
$num = mysql_num_rows($res);
$naamgeprint=false;
echo "<center><table>";
while($row = mysql_fetch_object($res)) {for ($i=0;$i<53;$i++){
if ($row->{"week$i"} == "v"||
$row->{"week$i"} == "mb" ||
$row->{"week$i"} == "wb"){
if ($naamgeprint==false) {
echo "<tr><td>$row->boot</td></tr>";
$naamgeprint=true;
}
echo "<tr><td>week$i</td></tr>";
}
}
}
echo "</table></center>\n";
?>
dit heb ik maar nu laat hij maar 1 bootnaam zien en zet hij alles onderelkaar zo dus
boot1
week10
week12
week13
week14
week15
week16
week17
week19
week20
week21
week23
week24
week25
week26
week10 dan zou hier dus de naam moeten staan van boot2(wat niet gebeurt
week12
week13
week14
week16
week17
week18
week19
week20
week21
week22
week24
week25
week26
ik wil dat dat meerdere kolomen worden zo dus
boot1 boot2 boot3 enz. enz. enz.
week10 week10 week10
week12 week11 week12
enz. enz. enz.
enz. enz. enz.
wat moet ik veranderen aan bovenstaand script?
$sql = "SELECT *
FROM demobeschikbaar
WHERE boot='$zoekjacht'";
$res = mysql_query($sql) or die(mysql_error());
$num = mysql_num_rows($res);
$naamgeprint=false;
echo "<center><table>";
while($row = mysql_fetch_object($res)) {for ($i=0;$i<53;$i++){
if ($row->{"week$i"} == "v"||
$row->{"week$i"} == "mb" ||
$row->{"week$i"} == "wb"){
if ($naamgeprint==false) {
echo "<tr><td>$row->boot</td></tr>";
$naamgeprint=true;
}
echo "<tr><td>week$i</td></tr>";
}
}
}
echo "</table></center>\n";
?>
dit heb ik maar nu laat hij maar 1 bootnaam zien en zet hij alles onderelkaar zo dus
boot1
week10
week12
week13
week14
week15
week16
week17
week19
week20
week21
week23
week24
week25
week26
week10 dan zou hier dus de naam moeten staan van boot2(wat niet gebeurt
week12
week13
week14
week16
week17
week18
week19
week20
week21
week22
week24
week25
week26
ik wil dat dat meerdere kolomen worden zo dus
boot1 boot2 boot3 enz. enz. enz.
week10 week10 week10
week12 week11 week12
enz. enz. enz.
enz. enz. enz.
wat moet ik veranderen aan bovenstaand script?