paging in alphabetically order
Moderator: General Moderators
-
firestar_lene
- Forum Newbie
- Posts: 10
- Joined: Mon Mar 29, 2004 2:04 am
paging in alphabetically order
how to do paging by alphabetically, where by data is from database?
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact:
Code: Select all
SELECT * FROM `users` ORDER BY `username` DESC-
firestar_lene
- Forum Newbie
- Posts: 10
- Joined: Mon Mar 29, 2004 2:04 am
paging
i want to do paging like page 1,page 2,page 3 but in alphabet..not arrange the data in alphabet order
if the name of the company is under A,
it will be in A category
A| B|C|D
if the name of the company is under A,
it will be in A category
A| B|C|D
Code: Select all
SELECT * FROM foo GROUP BY SUBSTRING(column, 1, 1)