[dudeking]

I am creating a dynamic menu, it consists of categorizes and menu items. Obviously many menu items can belong to a category. I have done allot of work with Access databases before and am more than adequate with PHP so I know what im trying to do but I'm very new to MySQL and phpmyadmin, How can I create a foreign key in the menu item table to link to the Menu Category table?

Thanks

[Blackmirror]

Articles and Tutorials - Managing Foreign Key Relationships In MySQL Using SQLyog

Is that any help Eddie ??

[dudeking]

Thanks BM that's exactly what I want to do but that is using SQLyog which seems to be some windows software. The interface I am using is called PHPmyadmin.

[Blackmirror]

Articles and Tutorials - Doing More With phpMyAdmin Part 2 of 2

There

[dudeking]

Thanks BM I've gotta go out now but I'll read through it when I get back tonight.

[Blackmirror]

I will keep looking and hoping someone here knows

[dudeking]

I've got PHP first thing tomorrow at college so I'll have to ask the tutor if he will go over some advanced SQL with me.