I have a page that is populated by a database informed by a value passed via a previous page.
It all works with the curious exception of the dropdown menu which for some reason omits the first record relating to the field.
For example
a customer has 4 seperate invoices pertaining to their customer id. 756, 757 , 758 , 759
The resulting dropdown contains 757 , 758 and 759 but doesnt have the 756 value.
what is occurring and how do i fix it?
kind regards
rob
// heres the relevant code
<form action = "insert_book.php" method= post>
<table border=0>
<?
Print ("<tr><td>Customer name </td><td><input type=text name=name value=\"$Row2[name]\"maxlength=2 size=30><br></td></tr> ");
Print ("<tr><td>PayMent recieved (y or n)</td><td><input type=text name=\"array[paygot]\" value=\"$Row2[paygot]\"maxlength=2 size=13><br></td></tr> ");
Print ("<tr><td>Date Invoiced </td><td><input type=text name=dateinv value=\"$Row2[dateinv]\"maxlength=2 size=13><br></td></tr> ");
Print ("<tr><td>OverDue By(days)</td><td><input type=text name=overdueby value=\"$Row2[overdueby]\"maxlength=2 size=13><br></td></tr> ");
Print ("<tr><td>Customer Type</td><td><input type=text name=custype value=\"$Row2[custype]\"maxlength=2 size=13><br></td></tr> ");
Print ("<tr><td>Amount </td><td><input type=text name=amount value=\"$Row2[amount]\"maxlength=2 size=13><br></td></tr> ");
Print ("<tr><td>CustomerID </td><td><input type=text name=\"array[custid]\" value=\"$Row2[custid]\"maxlength=2 size=13><br></td></tr> ");
//Print ("<tr><td>Invoice No</td><td><input type=text name=\"array[invoiceno]\" value=\"$Row2[invoiceno]\"maxlength=2 size=13><br></td></tr> ");
Print ("<tr><td>Next Invoice Due Out</td><td><input type=text name=\"array[nextinv]\"nextinv value=\"$Row2[nextinv]\"maxlength=12 size=13><br></td></tr> ");
Print ("<tr><td>Address</td><td><input type=text name=paygot value=\"$Row2[address]\"maxlength=2 size=13><br></td></tr> ");
Print ("<tr><td>Telephone</td><td><input type=text name=address value=\"$Row2[telephone]\"maxlength=2 size=13><br></td></tr> ");
?>
<tr><td>
<select name = "array[invoiceno]">
<?
$Row2 = mysql_fetch_array ($forthename);
while ($Row2= mysql_fetch_array ($forthename)) {
print ("<option value=$Row2[invoiceno]>$Row2[invoiceno]</option>\n");
}
mysql_close ($Link);
?>
</td></tr>
</select>
</table>
<INPUT TYPE="submit" NAME="submit">
</form>
