Weet iemand mischien wat ik hier fout doe.
Hij wil de list menu niet vullen.
<html>
<head>
<title>Formulieren en Facturen</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<?php
require_once('Connections/school.php');
mysql_select_db($database_school, $school);
$query_klant_menu = "SELECT Klantnaam FROM Klant";
$klant_menu = mysql_query($query_klant_menu, $school) or die(mysql_error());
$row_klant_menu = mysql_fetch_assoc($klant_menu);
$totalRows_klant_menu = mysql_num_rows($klant_menu);
?>
<body>
<?php
if (!isset($factuur))
{
echo ("<form name=form1 action=". $PHP_SELF. " method=post>");
echo ("<select name='klantnamen[]' size=6 multiple>");
do
{
echo ("<option value=".$row_klant_menu['Klantnaam'].">");
$row_klant_menu['Klantnaam'];
echo ("</option>");
} while ($row_klant_menu = mysql_fetch_assoc($klant_menu));
$rows = mysql_num_rows($klant_menu);
if($rows > 0)
{
mysql_data_seek($klant_menu, 0);
$row_klant_menu = mysql_fetch_assoc($klant_menu);
}
echo ("</select>");
echo ("<input name=submit type=submit value=submit>");
echo ("<input type=hidden name=factuur value=1>");
echo ("</form>");
}
else
{
//<!--> klantgegevens erbij zoeken -->
$klantresultaat = @mysql_query("SELECT Klantnummer, Klantadres, Klantpostcode, Klantwoonplaats
FROM Klant WHERE Klantnaam=$Klantnaam");
echo ("<table>");
while ( $row = mysql_fetch_array($klantresultaat))
{
$Klantnummer = $row["Klantnummer"];
$Klantadres = $row["Klantadres"];
$Klantpostcode = $row["Klantpostcode"];
$Klantwoonplaats = $row["Klantwoonplaats"];
echo ("<tr><td><b>Klantnummer:</b></td>");
$Klantnummer;
echo ("</td></tr>");
echo ("</table>");
}
}
?>
</body>
</html>
Zal wel helemaal niet mogeljik zijn wat ik hier probeer, maarja.
Hij wil de list menu niet vullen.
<html>
<head>
<title>Formulieren en Facturen</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<?php
require_once('Connections/school.php');
mysql_select_db($database_school, $school);
$query_klant_menu = "SELECT Klantnaam FROM Klant";
$klant_menu = mysql_query($query_klant_menu, $school) or die(mysql_error());
$row_klant_menu = mysql_fetch_assoc($klant_menu);
$totalRows_klant_menu = mysql_num_rows($klant_menu);
?>
<body>
<?php
if (!isset($factuur))
{
echo ("<form name=form1 action=". $PHP_SELF. " method=post>");
echo ("<select name='klantnamen[]' size=6 multiple>");
do
{
echo ("<option value=".$row_klant_menu['Klantnaam'].">");
$row_klant_menu['Klantnaam'];
echo ("</option>");
} while ($row_klant_menu = mysql_fetch_assoc($klant_menu));
$rows = mysql_num_rows($klant_menu);
if($rows > 0)
{
mysql_data_seek($klant_menu, 0);
$row_klant_menu = mysql_fetch_assoc($klant_menu);
}
echo ("</select>");
echo ("<input name=submit type=submit value=submit>");
echo ("<input type=hidden name=factuur value=1>");
echo ("</form>");
}
else
{
//<!--> klantgegevens erbij zoeken -->
$klantresultaat = @mysql_query("SELECT Klantnummer, Klantadres, Klantpostcode, Klantwoonplaats
FROM Klant WHERE Klantnaam=$Klantnaam");
echo ("<table>");
while ( $row = mysql_fetch_array($klantresultaat))
{
$Klantnummer = $row["Klantnummer"];
$Klantadres = $row["Klantadres"];
$Klantpostcode = $row["Klantpostcode"];
$Klantwoonplaats = $row["Klantwoonplaats"];
echo ("<tr><td><b>Klantnummer:</b></td>");
$Klantnummer;
echo ("</td></tr>");
echo ("</table>");
}
}
?>
</body>
</html>
Zal wel helemaal niet mogeljik zijn wat ik hier probeer, maarja.
laatste aanpassing






