lional Posted February 5, 2007 Share Posted February 5, 2007 Hi all I have tried Barend's baaselect and it is an excellent script. I would like to know if it handles joins. Here is my problem. I am writing a app for a non profit organization and I need to do the following. They assign certain members ranks. They have their organozation split into districts which in turn are split into chapters. I have created a logon per district so what I would like to do is to select the chapters that belong to a chapter and this is dependent on what logon was used. I want then to list the chapters that belong to that district. I have a table called membership and this lists which members belong to which chapter by linking the member_no from the membership table to the member_no in the personal details table. I would like to use your script to link the members from the membership table and then pull their name from the personal details table by joining the two tables by their member_no. Members can belong to more than one chapter. Any help will be appreciated Thanks Lional Link to comment https://forums.phpfreaks.com/topic/37191-baaselect/ Share on other sites More sharing options...
lional Posted June 2, 2008 Author Share Posted June 2, 2008 Hi all I have tried Barend's baaselect and it is an excellent script. I would know if there is anyway that this can be adapted to do the following. Using the script as is and adding an all option so that if for example we are looking for property in a province we can select all that will cascade to list all the cities available and a city can then be chosen and again all can be chosen etc Any help will be appreciated Thanks Lional Link to comment https://forums.phpfreaks.com/topic/37191-baaselect/#findComment-555412 Share on other sites More sharing options...
bilis_money Posted June 2, 2008 Share Posted June 2, 2008 why not wait for barand for a while. i'm sure he will be here. and ask him. Link to comment https://forums.phpfreaks.com/topic/37191-baaselect/#findComment-555438 Share on other sites More sharing options...
Barand Posted June 2, 2008 Share Posted June 2, 2008 It was designed only for heiarchical situations like this (where PKs and FKs are integers): [pre] country region city -------- ------- -------- countryID -+ regionID -+ cityID country | region | city +- countryID +- regionID [/pre] However, as a workaround you could create a temporary table from your joined data and use the temp table. Alternatively, use AJAX for the more complex situations Link to comment https://forums.phpfreaks.com/topic/37191-baaselect/#findComment-555500 Share on other sites More sharing options...
lional Posted June 2, 2008 Author Share Posted June 2, 2008 Thanks Barand I am not that experienced in PHP so excuse my next question? What do you mean about creating a temporay table from my joined data. I have the cascading menu working fine except for the all section Thanks in advance Lional Link to comment https://forums.phpfreaks.com/topic/37191-baaselect/#findComment-555518 Share on other sites More sharing options...
Barand Posted June 2, 2008 Share Posted June 2, 2008 The "all" option is dependent on your processing of the menus. The default option, no selection (value=0), should be treated as "all". So if the user only chooses from the first menu but not the second then only include the value from the first menu in the query. Link to comment https://forums.phpfreaks.com/topic/37191-baaselect/#findComment-555871 Share on other sites More sharing options...
lional Posted July 21, 2008 Author Share Posted July 21, 2008 Hi Barand What I need is an all on all levels. The app I need to do is the following. I need to list documents so my first search criteria will be a search field which is a dropdown. This must have an all field. Id the user selects the all then it will list all of the authors. It also has an all field. If the user selects the all again then all the provinces are listed. If he selects the all again, then all of the outcomes are displayed where he can select the relevent outcome or again select all. Any help will be appreciated Thanks Lional Link to comment https://forums.phpfreaks.com/topic/37191-baaselect/#findComment-595260 Share on other sites More sharing options...
lional Posted July 21, 2008 Author Share Posted July 21, 2008 Hi Barand I have tried your ajax and I just need to make a small change. The instead of an initial text box I would like a dropdown pulled from a mysql table. Can you give me some pointers please Thanks Lional Link to comment https://forums.phpfreaks.com/topic/37191-baaselect/#findComment-595341 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.