Jump to content


Photo

list menu tutorial


  • Please log in to reply
3 replies to this topic

#1 queslett

queslett
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 06 April 2004 - 08:00 PM

I can createa a MySQL database, and using MX2004 retrieve the information

I can also creat a dropdown List/menu

But I cannot find a tutorial that enables me to get the dropdown list to retrieve the information from the database using PHP

many thanks in anticipation for any help and advice.

Kind regards

Richard
Birmingham
England

#2 morpheus.100

morpheus.100
  • Members
  • PipPipPip
  • Advanced Member
  • 145 posts

Posted 06 April 2004 - 09:32 PM

This is a common question asked in this forum. The answer lies in the dreamweaver help files. Press F1. Look in developing php applications readily and there are walk throughs in the standard manual. Alternatively there is a better manual on the macromedia site. If you cant find it or it no longer exists by any chance email morpheus.100@virgin.net and I will send it. Its a pdf doc.


#3 morpheus.100

morpheus.100
  • Members
  • PipPipPip
  • Advanced Member
  • 145 posts

Posted 06 April 2004 - 09:33 PM

This is a common question asked in this forum. The answer lies in the dreamweaver help files. Press F1. Look in developing php applications readily and there are walk throughs in the standard manual. Alternatively there is a better manual on the macromedia site. If you cant find it or it no longer exists by any chance email morpheus.100@virgin.net and I will send it. Its a pdf doc.


#4 homchz

homchz
  • Members
  • PipPipPip
  • Advanced Member
  • 93 posts
  • LocationLee, New Hampshire

Posted 07 April 2004 - 06:10 PM

Are you trying to do this with out submitting? As I have no idea how tha woudl work, but...

I have one set up and working where enter a pull down list in a form and create a query to dipsplay the info in the pull down dynamically, and then name the list field. I then and a submit button and link the form to the page that display the info.

I use this so out two people controling our equipment inventory can echange information on each model back and forth. Each model is in the pull down, once selected they can edit the information it brings up.

Query to pull information diplayed in menu/list
SELECT model
FROM yankee_equipment_inv
ORDER BY model ASC

I am using MySQL and I write a query to select information by what is displayed in the list when submitted.

Query to pull info from menu/list
SELECT id, model, stock, sold, on_order, comments
FROM yankee_equipment_inv
WHERE model = 'colname'
ORDER BY model ASC

colname = name of list/menu this is set then you create the recordset in DW.

This worked for me fairly easily, though I might not be explaining it right.
I can try to give more information if you need it.

Josh




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users