If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > Drop down list

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-06-10, 08:48
berniez berniez is offline
Registered User
 
Join Date: Oct 2010
Posts: 5
Drop down list

Hi all, I have a slight problem as to a dropdown list. I have a form to add a record with a couple of dynamic dropdown lists and all working well. What I need to do is when I edit the data in the edit form how do I bind the existing data to the dropdown list, so that when they edit they can only select from the droplist. I am using php/mysql and dreamweaver CS4. Any help appreciated.
Reply With Quote
  #2 (permalink)  
Old 10-06-10, 11:19
it-iss.com it-iss.com is offline
Registered User
 
Join Date: Sep 2009
Location: San Sebastian, Spain
Posts: 620
Hi,

can you give an example of what you are trying to achieve? I think what you are looking to achieve is exclusively to the browser page? If this is the case you will need to use javascript on the browser page to disable or even to dynamically build the dropdown list. If you can give a clear example of what you are trying to achieve I might be able to help. However, I think that the post is outside the scope of MySQL.
__________________
Ronan Cashell
Senior Oracle/MySQL DBA
http://www.it-iss.com
Reply With Quote
  #3 (permalink)  
Old 10-09-10, 20:34
berniez berniez is offline
Registered User
 
Join Date: Oct 2010
Posts: 5
Dropdown

Thanks for your answer but I actually worked it out and seems to be working fine (so far). Thanks
Reply With Quote
  #4 (permalink)  
Old 10-10-10, 05:02
healdem healdem is online now
Jaded Developer
 
Join Date: Nov 2004
Location: out on a limb
Posts: 9,250
...and you solution was?
one of the aims of a forum like this is to provide answers, so it may help others who have the same problem as you to say what the solution you've found is
__________________
I'd rather be riding my Versys or my Tiger 800 let alone the Norton
Reply With Quote
  #5 (permalink)  
Old 10-13-10, 00:36
berniez berniez is offline
Registered User
 
Join Date: Oct 2010
Posts: 5
result

Thanks for your repy. Using dreamweaver I wasn't sure had to conect the dropdown list to the already data stored. On the edit form page I selected the dropdown list then went into properties then selected the dynamic button instead of the list button, picked the recordset then the field and bound them that way. This seemed to have worked. So when the form is live in the edit mode, the old data is bound to the select droplist and you can still choose the other options from the list. I hope this helps others out. Thanks guys.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On