[NickToye]

Hi,

I am a bit of a newbie here, so please bear with me.

I am trying to develop a sample application for a restaurant. I have two tables in my database:

menuType
menu

menuType has 2 fields

id_type(pk)
title_type

menu has 5 fields

id_menu(pk)
idtype_menu(fk)
title_menu
description_menu
price_menu

Ok, so in Dreamweaver I have managed to display my menu types in the index page:

starters
mains
desserts

In my menu.php page I want to be able to dynamically display the starters or whatever I select from the index.php.

Ok, so far this is working, apart from when I try to dynamically load in the starters etc...

Here is the sql query that I use to define my record set in the menu.php page:

SELECT *
FROM menu INNER JOIN menuType ON idtype_menu = id_type
WHERE idtype_menu = colname

And in the variables box I have:

Name Default Value Run-time Value
colname 1 $_GET['idtype_menu']

Any suggestions to how I can get this to work. If someone is interested in helping me, I can email the files so you can see more clearly what I am getting at.

Many thanks in advance.

Nick

[smallbeer]

OK so for instance you want to click starters on index.php and be taken to a list of all the starters in menu.php? right?

No need for the INNER JOIN.

SELECT * FROM menu WHERE idtype_menu = colname

colname is the menu type's id.

[NickToye]

Ok, cool, I actually worked it out but I never got rid of the Inner Join. I suppose it works regardless of this bit of sql. Out of interest what is the benefit of INNER JOIN?

[smallbeer]

Inner Join is used when you would like to select one or more rows from two or more related tables.