gina
|
| Posted: 06/11/2003, 8:00 AM |
|
I have a tree menu that currently displays in order by category_id. I would like it to display in alphabetical order. Any suggestions? I use CodeCharge 2 and php4 with templates.
|
|
|
 |
glerma
|
| Posted: 06/11/2003, 8:42 PM |
|
Umm.. By default most relational databases will order rows alphabetically by using the ORDER BY clause, which it seems your doing already. Just add whatever column you want to order alphabetically to your ORDER BY list.
You could try
Example Table.
category_id
category_name
ORDER BY category_id, category_name
Regards,
g.
|
|
|
|
|
