StJames Posted October 22, 2003 Share Posted October 22, 2003 Ok i have a database which consists of name num i want it to sort the name by alphabetical order, but only show the a\'s on one page.. then you can click to go to the b\'s. or the z\'s and so forth. Do you put that in your mysql query? Or what? Please HELP! James Quote Link to comment Share on other sites More sharing options...
effigy Posted October 22, 2003 Share Posted October 22, 2003 look into the pagination tutorials and use the numbers to base your search. for example: if page 1: search for name like \'a%\' if page 2: search for name like \'b%\' Quote Link to comment Share on other sites More sharing options...
sir nitr0z Posted October 22, 2003 Share Posted October 22, 2003 to order your rows alphatabetically you will ned to use $sql = \'ALTER TABLE `tablename` ORDER BY `name` \'; Quote Link to comment Share on other sites More sharing options...
StJames Posted October 22, 2003 Author Share Posted October 22, 2003 hrmm, could you give me an example(code) on how to print all of that? Quote Link to comment Share on other sites More sharing options...
sir nitr0z Posted October 23, 2003 Share Posted October 23, 2003 unfortunately i cant, however it should be quite simple. first you would need to examine the string for each name and determine the first character. if that sounds like alot of work then just make a new column in the database and put the first letter of each name in it. then u can use the query [php:1:1a7169a4f9]<?php $query = SELECT * WHERE startletter LIKE \'$letteryouwanttodisplay%\' ?>[/php:1:1a7169a4f9] play around with those ideas and see what you get. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.