Northumberland
asked on
Database integration
Can someone please tell me how I do the following in Dreamwever :
I want a list box on a web page that gets its values from a database called PRS.mdb a table called dbo_PRODUCT and a field called PRODUCTCODE. When the user selects an item on the list I also want a text box to display the description that corresponds to the product code. FOr example the layout of the table is :
PRODUCTCODE DESCRIPTION
Also I want to create a text box where the user can enter feedback. I then want them to click a button called Save which will add the record to a table called Comments which has fields of PRODUCTCODE and COMMENTS. So I want to be able to tell the form to add the record and use the PROUCTCODE that was selected in the list.
Can someone please help me through my learning curve ?
I want a list box on a web page that gets its values from a database called PRS.mdb a table called dbo_PRODUCT and a field called PRODUCTCODE. When the user selects an item on the list I also want a text box to display the description that corresponds to the product code. FOr example the layout of the table is :
PRODUCTCODE DESCRIPTION
Also I want to create a text box where the user can enter feedback. I then want them to click a button called Save which will add the record to a table called Comments which has fields of PRODUCTCODE and COMMENTS. So I want to be able to tell the form to add the record and use the PROUCTCODE that was selected in the list.
Can someone please help me through my learning curve ?
hi Northumberland,
Please follow this Link, it will show you how to use ASP with the Dreamweaver.
Feel Free if you have any questions.
http://www.fordwebs.com/tutorials/mx-asp/index.asp
Please follow this Link, it will show you how to use ASP with the Dreamweaver.
Feel Free if you have any questions.
http://www.fordwebs.com/tutorials/mx-asp/index.asp
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Gladxml. Sorry about the delay in accepting your answer I lost track of the question !
What are you using on your server? PHP and MySql?
Without knowing in which language you connect to the database, this could be difficult ;-)
-klykken