Form / MySql post problemer
Mit problem med flg kode er at hvis to felter i formen har samme varenr bliver kun den ene vist.Og udfylder man $varenr1 og $varenr3 i formen kludrer den i $antal kollonen....
Hjælp :)
Kode:
<html>
<body>
<?php
$conn = mysql_connect ("localhost" , "xcom_coolcarddb", "o89c") ;
mysql_select_db("lr_test",$conn);
$sql = "SELECT * from Vare WHERE varenr = '$varenr1' OR varenr = '$varenr2'
OR varenr = '$varenr3' OR varenr = '$varenr4' OR varenr = '$varenr5'
OR varenr = '$varenr6' OR varenr = '$varenr7' OR varenr = '$varenr8'
OR varenr = '$varenr9' OR varenr = '$varenr10' OR varenr = '$varenr11'
OR varenr = '$varenr12' OR varenr = '$varenr13' OR varenr = '$varenr14'
OR varenr = '$varenr15' OR varenr = '$varenr16'OR varenr = '$varenr17'
OR varenr = '$varenr18' OR varenr = '$varenr19' OR varenr = '$varenr20'";
$result = mysql_query($sql,$conn);
if($submit)
{
echo "<form method='post' action='". $GLOBALS['PHP_SELF'] ."'>\n";
for($i = 1; $res = mysql_fetch_array($result); $i++)
{
$varenavn = $res['varenavn'];
$varenr = $res['varenr'];
$antal = "antal". $i;
echo
"<input type='text' name='varenr". $i ."' value='$varenr'>\n".
"<input type='text' name='varenavn". $i ."' value='$varenavn' disabled>\n".
"<input type=''text' name='antal". $i ."' value='".$$antal."' size=4><BR>\n";
}
echo
"<input type='submit' name='submit' value='Send'>\n".
"</form>";
}
else
{
echo
"<H1>NY ORDRE</H1><BR>Indtast Varenr og Antal<BR>\n".
"<form method='post' action='". $GLOBALS['PHP_SELF'] ."'>\n";
for($i = 1; $i <= 20; $i++)
{
echo
"<input type='text' name='varenr". $i ."' value='' size=25> ".
"<input type='text' name='antal". $i ."' value='' size=4><BR>\n";
}
echo
"<input type='submit' name='submit' value='Videre ->'>\n".
"</form>\n";
}
mysql_close($conn);
?>
</body>
</html>
