I have a script that selects records from database and diplays them all into the same for, however I just realized that people with slower computers are having a problem where the select boxes are not showing up as they scroll down. Please help any suggestions, would be greatly appreciated.
Here the code.
<?php
mysql_connect("");
mysql_select_db("");
$query = "SELECT * FROM KEYCAD WHERE HOLD LIKE 'N' AND CUSTOMERNOTREACHED LIKE '0' AND FOLLOWUPCONTACT LIKE 'N' AND DEACTIVATE LIKE '0' ORDER BY CUSTNO AND CONTACTDATE DESC";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)) {
echo "<form method='post' action='submit.php?action=change' name='form' onsubmit='return validate(this)'>";
echo "<table border=2 bordercolor=#5E3964>\n";
echo "<tr>
<td><font color=#FF0000>Name</font></td>
<td><font color=#FF0000>Home #</font></td>
<td><font color=#FF0000>Work #</font></td>
<td><font color=#FF0000>Car Model</font></td>
</tr>\n";
printf("
<tr>
<input type='hidden' name=RO value='%s'>
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</td>
</tr>\n",
$row["RO"],
$row["CUSTOMERNAME"],
$row["HOMEPHONE"],
$row["BUSPHONE"],
$row["MODEL"]
);
echo "<tr>
<td><font color=#FF0000>Hot Spot</font></td>
<td><font color=#FF0000>Make Another Attempt</font></td>
<td><font color=#FF0000>Fixed Correctly?</font></td>
<td><font color=#FF0000>Treatment?</font></td>
</tr>\n";
printf("
<tr>
<td><input type=checkbox name=FOLLOWUPCONTACT value='Y'></td>
<td><input type=checkbox name=CUSTOMERNOTREACHED value='1'></td>
<td><select name=Q1><option selected></option><option>N</option><option>Y</option></select></td>
<td><select name=Q2><option selected></option><option>N</option><option>Y</option></select></td>
</tr>\n",
$row[""]
);
echo "<tr>
<td><font color=#FF0000>Clear Explanation?</font></td>
<td><font color=#FF0000>Overall Service?</font></td>
<td><font color=#FF0000>Why Not Fixed?</font></td>
<td><font color=#FF0000>Comments</font></td>
</tr>\n";
printf("
<tr>
<td><select name=Q3><option selected></option><option>N</option><option>Y</option></select></td>
<td><select name=Q4><option selected></option><option>N</option><option>Y</option></select></td>
<td><select name=Q5><option selected></option><option>1</option><option>2</option><option>3</option><option>4</option><option>5</option></select></td>
<td><input type=text name=COMMENTS value='%s'></td>
</tr>\n",
$row["COMMENTS"]
);
echo "<tr>
<td><font color=#FF0000>Happy</font></td>
<td><font color=#FF0000>Close Date</font></td>
<td><font color=#FF0000>Deactivate</font></td>
<td><p align='right'><A HREF='' onclick='drawAlert()'>HELP?</A></p></td>
</tr>\n";
printf("
<tr>
<td><input type=checkbox name=HAPPY value='1'></td>
<td>%s</td>
<td><input type=checkbox name=DEACTIVATE value='1' onclick=\"return confirm('ARE YOU SURE YOU WANT TO DEACTIVATE THIS CUSTOMER?')\" ></td>
<td><input type=submit name=submit value=submit></td>
</form></tr></table>\n",
$row["CLOSEDATE"]
);
}
?>
Sorry to post the whole code but I think it will help.
