Re: Displaying in Alphabetical Order

Ade, Here's some sql help for the query: "SELECT * FROM yourTableName ORDER BY yourSurnameField ASC LIMIT 20" For the second part of your question you need to use sql offsets combined with limits. I don't know of a quick fix for understanding this concept, although http://www.wdvl.com has some good tutorials for sql in general - of which I liked Selena Sol's best. Regards, Richard Creech richardc@dreamriver.com Phone: 250.744.3350 Pacific Time Canada Download phpYellow Pages 2000 - Now shipping Version 1.04 with EasySQL! Add Dynamic Database Content to your Website http://dreamriver.com/software/ From: Website4S@aol.com Message-ID: <32.b5e071e.271aa6cc@aol.com> Date: Sun, 15 Oct 2000 02:21:00 EDT To: php-general@lists.php.net MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit Subject: Displaying in Alphabetical Order Hi, 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? Thank you in advance Ade select * from yourTableName ORDER BY surname ASC LIMIT 20