list comparison

Hey Ray

On the attached gallerycat_insert have been trying to get the drop down (line 227) to retain the select on a failed validation. Have tried matching the value to the comparison but I dont think that makes sense as it needs to compare the CategoryID in the table gallery_category against the ProductContentsID from table gallery_category_contents

your advice gratefully received.

Jamie

on line 227 you have:

<option value="<?php echo($GallerySubCat->getColumnVal("CategoryID")); ?>" <?php if (!(strcmp($GallerySubCat->getColumnVal("ProductContentsID"), (ValidatedField("contentinsert","GallerySubCat"))))) {echo "selected=\"selected\"";} ?>><?php echo($GallerySubCat->getColumnVal("ProductName")); ?></option>

but the comparison has to match the option value, so it should probably be:

<option value="<?php echo($GallerySubCat->getColumnVal("ProductContentsID")); ?>" <?php if (!(strcmp($GallerySubCat->getColumnVal("ProductContentsID"), (ValidatedField("contentinsert","GallerySubCat"))))) {echo "selected=\"selected\"";} ?>><?php echo($GallerySubCat->getColumnVal("ProductName")); ?></option>

struggling with this one as I had already tried that (and tried it again) with no luck

not sure what is happening but the db is being updated appropriately depending on the selected option but if I echo the column value to the page its the same value (18) regardless of the item being updated...

Try:
<option value="<?php echo($GallerySubCat->getColumnVal("ProductContentsID")); ?>" <?php if (!(strcmp( $GallerySubCat->getColumnVal("ProductContentsID"), (ValidatedField("contentupdate","GallerySubCat")?ValidatedField("contentupdate","GallerySubCat"):$row_WADAgallery['GalleryPageID'])))) {echo "selected=\"selected\"";} ?>><?php echo($GallerySubCat->getColumnVal("ProductName")); ?></option>

thats done it! many thanks

I appreciate that the wadagallery records is being referenced, but is actually happening with that addition

:$row_WADAgallery['GalleryPageID']

youve added?

Yes that is so it will use the validated entry when it exists, otherwise it will get the value from the database to show the correct row.

gotcha thanks