ah I will try that :) also on the same page as you know I have parent categories and child categories stored on same table. and I am giving a value of '0' if its a parent category. and on my multi-select list I am grouping the child categories into their respective parents using :
<optgroup label=" ... ">
But I cannot figure out how to alter my recordset and create some kind of alias name so that I can display the parent name.
Using the following will display both parents and childs, so there is no way of distingusing from them unless I add in some kind of AS statement in my mysqli <?php echo($rsCategory->getColumnVal("CategoryName")); ?>
SELECT * FROM categories
I am using the column CategoryParentID (if it has a value of 0 then its a parent if it has any other numeric value then that value relates to the record in the database. (which will be any of the parents)