// create dept list
$queryUNIT = "SELECT UnitIndex, UNIT_NUMBER, UNIT_NAME FROM UNIT ORDER by UNIT_NAME";
$resultUNIT = mysql_query($queryUNIT) or die ("Error in queryUNIT: $queryUNIT. " . mysql_error());
while($rowUNIT = mysql_fetch_object($resultUNIT)) {
echo '<option value="'.$rowUNIT->UnitIndex.'">'.$rowUNIT->UNIT_NAME.' '.$rowUNIT->UNIT_NUMBER.'</option>';
}
I have this same query on two different forms....it creates select box option rows.
Both forms worked perfectly yesterday. Now, in form A the query doesn't run and the select box is empty. On form B it still works flawlessly.
The wierd thing is I changed it to Select * and it worked again...for five minutes. Now it is not working again. All other queires on Form A still work.
