MySQL Integration and multiple projects?

Taken From The Forum:
Forum Topic:
Last Updated: Saturday July 14 2012 - 06:07:13

MySQL Integration and multiple projects?

Poster: dougdrury
Dated: Saturday February 25 2006 - 18:38:40 GMT

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:

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:

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!!

Poster: Andy
Dated: Tuesday February 28 2006 - 8:45:10 GMT

Hi,

The Primary key is projectid in the mm_projects table.

The structure should be something like this:

Code:

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

Thanks.

Poster: dougdrury
Dated: Tuesday February 28 2006 - 15:05:58 GMT

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

Doug

Industrial Strength JavaScript and DHTML Menus

MySQL Integration and multiple projects?

Thanks.