Thanks - nmsinc

You may be able to do a show/hide based on the title instead.

The reason I need it this way is that the Plugin "showHideDependentFields" cannot use record numbers and I want the "other" selection to open/show another field!

Thanks - nmsinc

Add a type to your types section called Other, then use the code below:

<?php
$where = "";
$where = "WHERE (company = '".$CURRENT_USER['member']."' AND discontinue = '0') OR title = 'Other'";
?>
SELECT num, title
FROM `<?php
echo $TABLE_PREFIX ?>types`
<?php echo $where; ?>
ORDER BY dragSortOrder, title 

This will get it into the dropdown regardless of the selection, and it assumes that you have a drag sort order on the types section. The ordering may still not work though, you might have to play around with it.

Thanks - nmsinc

That's correct - I can't add it as a record!

Thanks - nmsinc

Please note that this additional option cannot be a record in the section and this is why I have not added it directly!

Any help would be appreciated – thanks nmsinc

<?php
$where = "";
$where = "WHERE company = '".$CURRENT_USER['member']."' AND discontinue = '0'";
?>
SELECT num, title
FROM `<?php
echo $TABLE_PREFIX ?>types`
<?php echo $where; ?>
ORDER BY title