Skip to main content
Participant
May 3, 2010
Question

AUTO Populate a Form's Field with MySQL Table Field(s) Data

  • May 3, 2010
  • 1 reply
  • 1239 views

Hi,

I can easily make forms that add, edit/update, delete.

But I want to be able to populate a form field (usually a popup field) with a selection of records from a specific table.

Say I have a table: CARS

That has fields: MODEL, MANUFACTURER, PRICE

I want to populate the form field named Model with all the CARS:MODEL values in the table.

...and some times...

I want to populate the form field named Model with all the CARS:MODEL values in the table where CARS:PRICE < 20,000

Now, I am fine with the whole HTML, MySQL, PHP programming and can do this all by long-hand coding.

But I'd like to speed it all up and use Dreamweaver! 🙂

AND I'd like the edit/update forms to also selected the current records value and make it SELECTED whilst also holding all the other values..., using Dreamweaver.

I can do this all by long-hand coding, but I'd like to speed up my development (and colleagues) and use Dreamweaver! 🙂

I hope all we need is a pointer to which menu items to use for this way of working within Dreamweaver...

Thank you,

This topic has been closed for replies.

1 reply

Participating Frequently
May 3, 2010

Take a look at DW's Dynamic Form Elements server behaviors.