MySQL Integration and multiple projects?

[dougdrury]

I have DHTML menus working just fine with MySQL, but would like to see a bit more documentation on using multiple projects.
I need to create 4 totally different menus that I can call seperatly by calling something like:

Code: Select all

buildMySQLMenu(1);
buildMySQLMenu(2);
buildMySQLMenu(3);
buildMySQLMenu(4);

I created another project in the mm_project table and the associated other tables, but when I use the

Code: Select all

buildMySQLMenu(2); // This line builds the menu from MySQL data tables.

item in my PHP page referencing the project 2, I get nothing to show up. My main question is...
What are the PK/FK relationships between the mm_projects,mm_menus,mm_items tables? Is there a link to some more docs on the MySQL integration for MySQL/PHP/Milonic?
Thank you!!

[Andy]

Hi,

The Primary key is projectid in the mm_projects table.

The structure should be something like this:

Code: Select all

mm_projects - PK: projectid
     |
     |_____mm_menus joined by projectid
             |  |
             |  |_____ mm_items joined by menuid
             |
             |_____ mm_styles joined by styleid

So, in essence, mm_projects is the parent table, menus are joined to the mm_projects table by the primary key: projectid. Styles are applied in the mm_menus table using the key styleid.

The menu items are joined using the menuid key

Hope this helps,
Andy

[dougdrury]

Thanks Andy.
This helps alot. I now have them working. I appreciate the PHP scripts they helped out a ton!!

Doug