Dynamic Selection Lists not working

I have some selection field lists on an add record page.

The Boat Type field and the Hull Materials field return only the first record from the list even when a different field was selected.

Can you please see where I am going wrong

I am attaching the page code. Perhaps I would do better to make the fields non dynamic.

Thanks

John

Can I get a url and FTP access? I'll debug it.

Thanks Ray
Please see PM

Lines 71-72 you have:
$InsertQuery->bindColumn("Category1", "s", "".($rsCatBoats->getColumnVal("Category")) ."", "WA_DEFAULT");
$InsertQuery->bindColumn("HullMaterial", "s", "".($rsHullMaterial->getColumnVal("HullMaterial")) ."", "WA_DEFAULT");

I think it should be:
$InsertQuery->bindColumn("Category1", "s", "".($_POST['Category']) ."", "WA_DEFAULT");
$InsertQuery->bindColumn("HullMaterial", "s", "".($_POST['HullMat']) ."", "WA_DEFAULT");

On line 260 you have:
<option value="<?php echo($rsCatBoats->getColumnVal("Category")); ?>"<?php if (!(strcmp($rsCatBoats->getColumnVal("Category"), ($rsCatBoats->getColumnVal("sort"))))) {echo "selected=\"selected\"";} ?>><?php echo($rsCatBoats->getColumnVal("Category")); ?></option>

I think it should be:
<option value="<?php echo($rsCatBoats->getColumnVal("Category")); ?>"<?php if (!(strcmp($rsCatBoats->getColumnVal("Category"), (ValidatedField("boatsInsert_531","Category"))))) {echo "selected=\"selected\"";} ?>><?php echo($rsCatBoats->getColumnVal("Category")); ?></option>

Thanks Ray,
Yes it appears to be working correctly now.
Have you any idea why this should occur ?

I could not see anything amiss with the dynamic List/Menu.
Strange how some Drop Downs were OK and some not.

Just thinking of next time and what not to do!
Anyway thanks again.
John

I can't say what caused it or when. I just saw the issues in the code. I can't really imagine the cause.