holly30 Posted June 19, 2006 Share Posted June 19, 2006 Hi all,I hope somebody can help me with the folowing:I'm trying to create a pulldown-navigation which is build enterily dynamic from a MySql database.I've got two tables in MySql, one with the main navigation options, and one with the pulldown options. The first thing i do is to create a repeat on the first table, which will give me with the main options in my navigation bar. No problem so far.Now i have to bind the right suboptions to the corresponding main option... and that's where the trouble starts.In my second MySql table i have a cell with the mainoption-positon which to relate to. How do i bind this to the right mainoption? Right know i'm using a nested repeat loop inside of the main-loop, but this is probably not the right way to go...My guess is i should use some kind of 'JOIN'? Unfortunately my MySQL knowledge stops just about there....Can somebody please point me in the right direction? thanks grtz, Holly Link to comment https://forums.phpfreaks.com/topic/12358-dynamic-navigation-phpmysql/ Share on other sites More sharing options...
holly30 Posted June 19, 2006 Author Share Posted June 19, 2006 UPDATE:I found another way to solve my problem. I've build my submenu-query according to the pulldown 'id' which is counting from 1 till the number of total main navigation options.If you have the answer the 'JOIN' way; i'd like to hear that anyway. I think that way is prettier and resource friendlier. Link to comment https://forums.phpfreaks.com/topic/12358-dynamic-navigation-phpmysql/#findComment-47284 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.