refreshing with a selection

[Anon]

Hi, I am having problems trying to refresh a page after the user selects a new account from a drop-down list:

echo "<select name='Code' onChange='requery(value)'>";

while ($row = mssql_fetch_array ($result)) {

if ($row["Code"] != null)
echo "<option value ='".$row["Code"]."'>".$row["Code"]."</option>";

</select>

[pnoeric]

jack - not real clear on what the problem is exactly, so I will offer you excellent help that will solve your problem, in the form of a series of questions:

have you done a 'view source' on the results to check that the html is written properlty?

have you made sure your data is in the db correctly?

have you tried re-writing your loop to just fetch each row from the db and echo it to the screen?

I promise, try all three items above and i'll bet you'll nail the problem along the way.

yours in basic debugging techniques,
eric