Grouping menu items
| From: | Kim Kohen | Date: | Tue, 02 Apr 2002 01:42:27 +0000 |
| Subject: | Grouping menu items | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-18105@lists.php.net to get a copy of this message | ||
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