https://www.machform.com/forums/ MachForm Community Forums Topic: Retrieving Dropdown Values en Mon, 04 May 2026 05:51:13 +0000 https://www.machform.com/forums/topic/retrieving-dropdown-values#post-19378 Sat, 12 Oct 2013 11:44:38 +0000 yuniar 19378@https://www.machform.com/forums/ <p>The above code only refer to the SQL code that can be placed into any custom script or any code within machform files that execute SQL. </p> https://www.machform.com/forums/topic/retrieving-dropdown-values#post-19342 Wed, 09 Oct 2013 00:15:26 +0000 fourward 19342@https://www.machform.com/forums/ <p>Where would that code go? </p> https://www.machform.com/forums/topic/retrieving-dropdown-values#post-9914 Tue, 13 Jul 2010 05:44:01 +0000 andylooney 9914@https://www.machform.com/forums/ <p>You guys got it! Thank you sooo much! </p> https://www.machform.com/forums/topic/retrieving-dropdown-values#post-9883 Thu, 08 Jul 2010 05:37:25 +0000 andylooney 9883@https://www.machform.com/forums/ <p>Okay, thanks! </p> https://www.machform.com/forums/topic/retrieving-dropdown-values#post-9879 Wed, 07 Jul 2010 19:42:37 +0000 yuniar 9879@https://www.machform.com/forums/ <p>Hi Andy,</p> <p>Can you send us your current code please?<br /> Also, let us know the URL to your form as well.</p> <p>Please send to: customer.service [at] appnitro.com<br /> We'll help you there. </p> https://www.machform.com/forums/topic/retrieving-dropdown-values#post-9875 Wed, 07 Jul 2010 06:12:09 +0000 andylooney 9875@https://www.machform.com/forums/ <p>Yeah, i found that post and the other one like it,but i can't seem to get that to work either. </p> https://www.machform.com/forums/topic/retrieving-dropdown-values#post-9871 Tue, 06 Jul 2010 13:42:43 +0000 redityo 9871@https://www.machform.com/forums/ <p>You can use these SQL code to get drop down value from mysql :</p> <pre><code>select A.*, B.option as element_6_value, C.option as element_7_value from (ap_form_271 as A left join ap_element_options as B on A.element_6=B.option_id and B.element_id=6 and B.form_id = 271) left join ap_element_options as C on A.element_7=C.option_id and C.element_id=7 and C.form_id=271</code></pre> <p>You need to change the form id and element id in there with yours. For further information, you can see to these post :</p> <p><a href="http://www.appnitro.com/forums/topic/drop-downs-and-mysql?replies=11" rel="nofollow">http://www.appnitro.com/forums/topic/drop-downs-and-mysql?replies=11</a> </p> https://www.machform.com/forums/topic/retrieving-dropdown-values#post-9866 Tue, 06 Jul 2010 07:11:14 +0000 andylooney 9866@https://www.machform.com/forums/ <p>Hi, I have spent the week and 30+ hours trying to retrieve the dropdown values from mach form mysql tables and to display them on a table on my website. I have read the posts explaining how to do a left join, i have learned about joins on my own, etc. I have even tried to write my way around this problem -but to no avail. I'm am finally frustrated enough to ask for help.<br /> Basically, I am using machforms as a tool for my employees to enter in data about various local companies. After they enter that data, it is stored in a mysql database.<br /> I then have a form on my website that consists of a dropdown menu, a checkbox array, and a submit button. A visitor to my site is supposed to be able to select a county from the dropdown and a type of company from the checkbox array. Then this posts to a script which hunts for the matching listings in the machforms databse and displays relevant results in a table.<br /> Since most of the data is entered in machforms through dropdown boxes, the hard part is getting my php script to query the machforms database correctly. I have connected a few times -but cannot get this to work correctly. HELP! </p>