SkyRanger Posted January 26, 2013 Share Posted January 26, 2013 Hi All, Firstly I would like to thank you all for all of the help that you have give me thus far. I have no code to post <--- Reason I need to figure out how to first start. Which brings me to this. I am looking for an example or tutorial (Searched google with little luck) on how I can output a table in alphabetical order but on different pages. I seen a code a while ago that would help me out but lost it. Example of what I am trying to do is print out the menu A - Z Show All I already have a basic idea on how to do this but not sure how to do the show all. SELECT * FROM `cinvent` WHERE oname='$client' and iname like '$letter%' And also I am trying to clean it up some to only link the letters that actually have something in the database. Thank you for your time. Quote Link to comment Share on other sites More sharing options...
trq Posted January 26, 2013 Share Posted January 26, 2013 To show all you would simply remove the like clause from your query. Quote Link to comment Share on other sites More sharing options...
SkyRanger Posted January 26, 2013 Author Share Posted January 26, 2013 Well the show all was easy enough....thank you. But do you know where I can find an example or tutorial for the A-Z to display but only link the letter that has something in it. Quote Link to comment Share on other sites More sharing options...
SkyRanger Posted January 26, 2013 Author Share Posted January 26, 2013 Think I found what I was looking for here in the forum: This is a good start for me http://forums.phpfreaks.com/topic/174582-alphabetical-pagination-help-needed/ 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.