https://www.machform.com/forums/ MachForm Community Forums Topic: Results that match form in database en Mon, 04 May 2026 00:08:30 +0000 https://www.machform.com/forums/topic/results-that-match-form-in-database#post-4026 Tue, 16 Dec 2008 19:18:19 +0000 redityo 4026@https://www.machform.com/forums/ <p>Hi,</p> <p>I think you want to get actual data form drop down list instead of drop down id.<br /> Try to use this sql, you should get actual data (not id) from your drop down element :</p> <pre><code>select B.option as month_element, C.option as year_element from (ap_form_2 as A left join ap_element_options as B on A.element_2=B.option_id and B.element_id=2 and B.form_id = 2) left join ap_element_options as C on A.element_3=C.option_id and C.element_id=3 and C.form_id=2</code></pre> <p>here is from another link </p> <p><a href="http://www.appnitro.com/forums/topic/mysql-question?replies=5" rel="nofollow">http://www.appnitro.com/forums/topic/mysql-question?replies=5</a></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/results-that-match-form-in-database#post-4025 Tue, 16 Dec 2008 19:05:57 +0000 yuniar 4025@https://www.machform.com/forums/ <p>Ron, sorry for delay!</p> <p>So, basically machform uses relational tables to optimize your database storage.<br /> For dropdowns, only their index number is being stored to your "ap_form_xxx" table.</p> <p>You need to lookup the value of those index numbers to other table, which is "ap_element_options" table.</p> <p>Can you let me know exactly what you are trying to do? What do you need with those month and year? </p> <p>Do you need to rename your file with those month and year? </p> https://www.machform.com/forums/topic/results-that-match-form-in-database#post-4023 Tue, 16 Dec 2008 00:24:46 +0000 rscott7706 4023@https://www.machform.com/forums/ <p>Just want to kick this up to see if anyone has an answer on it.</p> <p>Thanks!</p> <p>Ron </p> https://www.machform.com/forums/topic/results-that-match-form-in-database#post-4015 Sun, 14 Dec 2008 12:41:07 +0000 rscott7706 4015@https://www.machform.com/forums/ <p>Hey all...</p> <p>I am building an interface that will allow the relatively inexperienced employees of our Lakeside Chamber the ability to upload their newsletter and provide the link to it.</p> <p>I will upload the Adobe Acrobat file with a php uploader, not MachForm.</p> <p>But, I want to upload the month, Year and Link using MachForm.</p> <p>So, I built a form that has a month dropdown, and a year dropdown.</p> <p>The drawaback is that the database populates with integers, not the months or years I put in the form.</p> <p>For instance, the database will have a 1 in month and 1 in year if I select month - "January" and year "2009" (my first year is 2009).</p> <p>I tried to go in to the database and change the structure from int to text, but that did not help (as well as other change to match text).</p> <p>Here is the link to form: <a href="http://www.lakesideca.com/machform/view.php?id=2" rel="nofollow">http://www.lakesideca.com/machform/view.php?id=2</a></p> <p>Any ideas??</p> <p>Thanks!!</p> <p>Ron </p>