soddengecko Posted October 24, 2007 Share Posted October 24, 2007 hi all i am calling all data from a database and listing it in a table. The main trouble is that some sections will have a large amount of data in them with different categories. for example, i have a db of mobile phone manufacturers and models. as you can imagine there are a lot of them. so far i have the data paged with 30 results a page and it is all listed in alphabetical order by manufacturer so it is relatively easy to find data if you keep clicking through the lists. what i would like to do is have a set of links (which i have done using manufacturer as the title). how do i use those links for the following: if i click on Nokia for instance, how do i get ALL Nokia only phones listed and not show any other data? Quote Link to comment https://forums.phpfreaks.com/topic/74573-php-and-mysql-show-only-from-list/ Share on other sites More sharing options...
adam291086 Posted October 24, 2007 Share Posted October 24, 2007 i am a newbie to the php world, but heres an idea. Couldn't you create a page with a simple form with a drop down list of all the manufacturers. Then create a php scrpit that runs a query on your database with the value of that form once submitted. Quote Link to comment https://forums.phpfreaks.com/topic/74573-php-and-mysql-show-only-from-list/#findComment-376884 Share on other sites More sharing options...
soddengecko Posted October 24, 2007 Author Share Posted October 24, 2007 it's a good idea. one i have thought about doing. my client is somewhat daft and he has asked for a specific way of doing this. i see similar things on blogs with the archive sections. link is created for a given month, clicking it will list all posts from that month so my client is asking me to do the same thing for the app i am building. i have no idea what you would call this function so i am having trouble googling for it. Quote Link to comment https://forums.phpfreaks.com/topic/74573-php-and-mysql-show-only-from-list/#findComment-376887 Share on other sites More sharing options...
adam291086 Posted October 24, 2007 Share Posted October 24, 2007 well the simple way to do it will be to create a php page for every single manufacturer. Then link each manufactuerer to there specific php file. In the php file will be a simple select statement with the manufacturers name in it already . This is time consuming and as i dont know php well i couldn't suggest a function to do it. Quote Link to comment https://forums.phpfreaks.com/topic/74573-php-and-mysql-show-only-from-list/#findComment-376897 Share on other sites More sharing options...
soddengecko Posted October 24, 2007 Author Share Posted October 24, 2007 time consumption is not so much of a worry and it is a way of doing it. i would much prefer to have the function auto generate the page etc otherwise i am going to end up with a few hundred pages just to get what i need. i will keep thinking about it. anyone else have anything to throw into the mix? Quote Link to comment https://forums.phpfreaks.com/topic/74573-php-and-mysql-show-only-from-list/#findComment-376900 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.