<option>$row[0]</option> Probleem - Forum

Rick

22-04-2004 13:20

probeer het zo eens:
<?
echo '<option value="'.$_POST['compid'].'">'.$row[0].'</option>';
?>

P.v.Denzel

22-04-2004 13:57

Nee werkte ook niet ik hou dat wel vast moet ik nog van leren maar dit is het nu
<html><body background="img/rj45.jpg" vlink="#FFFFFF" alink="#FFFFFF">
<div align="center">
<table border="0" cellpadding="2" cellspacing="4" style="border-collapse: collapse" bordercolor="#111111" width="550" height="366">
<tr>
<td width="550" height="43" colspan="2">
<p align="center"><b><font size="4" face="Verdana" color="#FFFFFF">Klantendatabase</font></b></td>
</tr>
<tr>
<td width="150" height="20"><font face="Verdana" size="2" color="#FFFFFF"><a href="inloggen.php" target="_self">inloggen</a></font></td>
<td width="380" height="319" rowspan="7">
<?
require "connect.php";
$datumin = date("d.m.Y");
$datumuit = date("d.m.Y");
if ($_POST['merk'] && $_POST['type'] && $_POST['oms'] && $_POST['sn'])
{
$sql = "INSERT INTO kcomponent (compid, merk, type, oms, sn, datumin, datumuit, hsid) VALUES ('$compid', '$merk', '$type', '$oms', '$sn', '$datumin', '$datumuit', '$hsid')";
$res = mysql_query($sql)or die (mysql_error());
if ($res)
{
echo "gegevens zijn verwerkt<p>";
echo "Ga naar <a href=\"overzichtonderdelen.php\">volgende</a>.";
}
else
{
echo "Sorry niet aangemeld. Er is iets misgegaan met het invoeren in de database.";
echo "<a href=\"inhoud.php\">Probeer het nog eens</a>";
}
}
else
{
if ($_POST["submit"])
echo "Enkele velden vergeten!";

echo "<div align='center'>";
echo "<center>";
echo "<table border='0' cellpadding='0' cellspacing='0' style='border-collapse: collapse' bordercolor='#111111' width='380' height='169'>";
echo "<tr><td width='380' height='117' align='center' colspan='2'><font color='#FFFFFF' size='4'face='verdana'>Nieuwe hardwarecomponent<br>toevoegen</font></td></tr>";
echo "<tr><td>";
echo "<form method='POST' action='$php_self'><select size='1' name='onderdelen'>";
$sql = "SELECT * FROM comp_oms_id";

$res1 = mysql_query($sql)or die(mysql_error());
if (mysql_num_rows($res1) >= 1 )
{
while
($row = mysql_fetch_row($res1))
{
echo '<option value="'.$_POST['compid'].'">'.$row[1].'</option>';
}
}
echo "</select>";
echo "$hsid</td></tr>";
echo "<tr><td width='190' height='25'align='right'><font face='Verdana' color='#FFFFFF'>Merk:</font></td>";
echo "<td width='190' height='15'><input type='text' style='border-style: dashed; border-width: 0' maxlength='20' size='20' name='merk' value='$_POST[merk]'></td></tr>";
echo "<tr><td width='190' height='15' align='right'><font face='Verdana' color='#FFFFFF'>Type:</font></td>";
echo "<td width='190' height='15'><input type='text' style='border-style: dashed; border-width: 0' maxlength='20' size='20'name='type' value='$_POST[type]'></td></tr>";
echo "<tr><td width='190' height='15' align='right'><font face='Verdana' color='#FFFFFF'>Omschrijving:</font></td>";
echo "<td width='190' height='15'><input type='text' style='border-style: dashed; border-width: 0' maxlength='255' size='20'name='oms' value='$_POST[oms]'></td></tr>";
echo "<tr><td width='190' height='15' align='right'><font face='Verdana' color='#FFFFFF'>Serial nummer:</font></td>";
echo "<td width='190' height='15'><input type='text' style='border-style: dashed; border-width: 0' maxlength='7' size='7' name='sn' value='$_POST[sn]'></td></tr>";
echo "<tr><td width='380' height='15' colspan='2'>";
echo "<input type='submit' value='Verzenden' name='submit'></td></tr>";
echo "</form></table>";
echo "</center>";
echo "</div>";
}

?>
</td>
</tr>
<tr>
<td width="150" height="20"><font face="Verdana" size="2"><a style='color: #FFFFFF' href="overzichtklanten.php" target="_self">klanten
overzicht</a></font></td>
</tr>
<tr>
<td width="150" height="20"><font face="Verdana" size="2">zoek</font></td>
</tr>
<tr>
<td width="150" height="20"><font face="Verdana" size="2">etc</font></td>
</tr>
<tr>
<td width="150" height="20"><font face="Verdana" size="2"><a style='color: #FFFFFF' href="invulklanten.php" target="_self">nieuwe<br>klanten<br>invoer.</a></font></td>
</tr>
<tr>
<td width="150" height="20"><font face="Verdana" size="2"><a style='color: #FFFFFF' href="index.php" target="_self">home</a></font></td>
</tr>
<tr>
<td width="150" height="190"> <td>
</tr>
</table>
</div></body></html>

?

Onbekende gebruiker

22-04-2004 15:05

<?
echo '<option value="'.$_POST['compid'].'">'.$row[1].'</option>';
}
}
echo "</select>";
?>

waar begin je de <select> die staat er niet in

P

P.v.Denzel

22-04-2004 15:19

echo "<tr><td>";
echo "<form method='POST' action='$php_self'><select size='1' name='onderdelen'>";