Hello All, I have a MySql database which has a 'sections' column which includes values such as Real Estate, Sport, Letters etc. The 'News' section is divided into 4 parts to indicate a priority for any given story; News, News2, News3 and News4.
We are using: $getlist1 = mysql_query("SELECT distinct Section FROM stories"); to populate a popup menu which returns each of the 'News', News2, News3 and News4 items as separate rows in the popup. Ideally I'd like to have all the 'News' variants appear under a single 'News' menu item rather than separately. Can anyone suggest a way to group these entries together or to truncate the digit off the end without effecting any other menu item? cheers kim -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php