thanks for the clarification and pointer... got that all working.
what I havent managed to get working is that when in the update page, the category that is showing as the selected one is always the top category rather than the one that was selected.
<select name="ProductCategory">
<?php do { ?>
<option value="<?php echo $row_Categories['CategoryID']; ?>" ><?php echo $row_Categories['CategoryName']; ?></option>
<?php } while ($row_Categories = mysql_fetch_assoc($Categories)); ?>
</select>
Have attached the file if if helps...
Cheers