RE: [PHP] Displaying in Alphabetical Order
| From: | Jason Murray | Date: | Sun, 15 Oct 2000 07:32:07 +0000 |
| Subject: | RE: [PHP] Displaying in Alphabetical Order | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-20220@lists.php.net to get a copy of this message | ||
> I have a MySQL database which holds users registered info,
> one of the fields is their surname, does anyone know the PHP code
> that would let me display all the users 20 per page in alphabetical
> order according to their surname with the little numbers for moving
> between pages faster?
Add "ORDER BY surname" to your SQL statement.
Jason
--
Jason Murray
jasonm@melbourneit.com.au
Web Design Team, Melbourne IT
Don't believe everything you're foretold.