Exclude options in category drop down in form

Claire,

Thank so much, that worked perfectly. Can I include an order by clause  so that the options in the drop down will display in the same drag/sort order that I have them in the category menu vs sorting them by id num?

Thanks!

April

Yes of course. It's a straightforward SQL statement so you can just add this to it:

ORDER BY dragSortOrder

Like this:

Feel like I am missing some syntax

SELECT fieldname1, fieldname2
FROM `<?php echo $TABLE_PREFIX ?>tableName` WHERE hidden = 0 ORDER BY dragSortOrder

Nope, looks good to me. Just make sure you change the fieldnames/tablename.

Claire,

I just noticed something. Need your help. This option works great but it is effecting the drop down in the CMS backend as well as on the form because of the advanced coding. I only want the excluded options to show on the form not in the backend. Can I just include some code on the actual form page to exclude options in the list only for form page and not in backend?

Ah I see, I thought you meant the CMS form, not a front end form.

You can use something similar on the front end to make this work as well. Can you show me the code you're using to get the options for the front end dropdown?

Sure :

<select name="category">
<option value = "">-Select-</option>
<?php foreach (getListOptions($tableName, 'category') as $value => $label): ?>
<option value = "<?php echo htmlspecialchars($value);?>" <?php selectedIf($value, @$_REQUEST['category']);?>> <?php echo htmlspecialchars($label);?> </option>
<?php endforeach ?>
</select>

You'll have to change this. You can't use getListOptions with a custom WHERE clause. What's the name and structure of the table where you're storing the categories?