October 21st, 2004, 04:06 PM
Join Date: Oct 2004
Time spent in forums: < 1 sec
Reputation Power: 0
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 has 2 fields
menu has 5 fields
Ok, so in Dreamweaver I have managed to display my menu types in the index page:
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:
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.