https://www.machform.com/forums/ MachForm Community Forums Topic: drop downs and MySQL en Wed, 06 May 2026 02:13:49 +0000 https://www.machform.com/forums/topic/drop-downs-and-mysql#post-1417 Sat, 19 Apr 2008 16:39:34 +0000 Molina 1417@https://www.machform.com/forums/ <p>:-) Great!<br /> Thanks, how easy things can be... </p> https://www.machform.com/forums/topic/drop-downs-and-mysql#post-1408 Sat, 19 Apr 2008 07:33:46 +0000 yuniar 1408@https://www.machform.com/forums/ <p>Oops..you are right. I forgot that checkboxes only have Yes (1) or No (0) values.</p> <p>A little adjustment is needed to your query. Try this:</p> <pre><code>SELECT A.*, B.option AS element_2_1_value, C.option AS element_2_2_value FROM (ap_form_28 AS A LEFT JOIN ap_element_options AS B ON A.element_2_1=1 AND B.element_id=2 AND B.option_id=1 and B.form_id=28) LEFT JOIN ap_element_options AS C ON A.element_2_2=1 AND C.element_id=2 AND C.option_id=2 and C.form_id=28</code></pre> <p><code></code> </p> https://www.machform.com/forums/topic/drop-downs-and-mysql#post-1400 Fri, 18 Apr 2008 18:48:50 +0000 Molina 1400@https://www.machform.com/forums/ <p>Hi,</p> <p>I've got 2 checkboxes, for example (I hope it's understandable):<br /> checkbox 1 = element_id 2, option_id 1, option = "first V"<br /> checkbox 2 = element_id 2, option_id 2, option = "second V"<br /> The query</p> <p>SELECT<br /> A.*,<br /> B.option AS element_2_1_value,<br /> C.option AS element_2_2_value<br /> FROM<br /> (ap_form_28 AS A<br /> LEFT JOIN ap_element_options AS B<br /> ON A.element_2_1=B.option_id AND B.element_id=2 AND B.form_id=28)<br /> LEFT JOIN ap_element_options AS C<br /> ON A.element_2_2=C.option_id AND C.element_id=2 AND C.form_id=28</p> <p>is working correctly for the first element.<br /> But the second choice alway returns the value of the first one; it inserts "1" into the database as you can see in the source code of the html-page:<br /> &lt;input id="element_2_2" name="element_2_2" class="element checkbox" type="checkbox" value="1" /&gt;.<br /> If I want to output the value "second V" written in ap_element_options of the second checkbox too I have to change the datatabase in ap_form_28 from "1" to "2", then the output is what I'd like to get: "second V".<br /> Is there something wrong?<br /> Or is there normally only a Yes- or No-option?<br /> Thanks again for help!<br /> Molina </p> https://www.machform.com/forums/topic/drop-downs-and-mysql#post-1398 Fri, 18 Apr 2008 13:45:30 +0000 yuniar 1398@https://www.machform.com/forums/ <p>Molina, the query would be exactly the same as dropdowns.<br /> Checkboxes and dropdowns are treated similar.</p> <p>Post your query here if you can't seem to make it work.<br /> I'll try to help. </p> https://www.machform.com/forums/topic/drop-downs-and-mysql#post-1393 Fri, 18 Apr 2008 13:03:36 +0000 Molina 1393@https://www.machform.com/forums/ <p>Hi,</p> <p>Yuniar, how can I extract the values for checkboxes via MySQL in a query? Would you please help me again?<br /> Thanks<br /> Molina </p> https://www.machform.com/forums/topic/drop-downs-and-mysql#post-1372 Thu, 17 Apr 2008 07:03:04 +0000 yuniar 1372@https://www.machform.com/forums/ <p>You will be able to create forms which connect to your mysql database. all submission will be stored on your database. </p> https://www.machform.com/forums/topic/drop-downs-and-mysql#post-1362 Wed, 16 Apr 2008 17:49:44 +0000 expat 1362@https://www.machform.com/forums/ <p>i thought in another post the admin says you can populate a drop down list???</p> <p>So with this you can actually generate a php form that connects to the Mysql?? </p> https://www.machform.com/forums/topic/drop-downs-and-mysql#post-1337 Fri, 11 Apr 2008 22:40:37 +0000 Molina 1337@https://www.machform.com/forums/ <p>Yuniar, you're great!<br /> Thanks a lot, it works fine and I learned a little bit more :-)<br /> Maybe I will have to ask another question...</p> <p>Molina </p> https://www.machform.com/forums/topic/drop-downs-and-mysql#post-1332 Fri, 11 Apr 2008 06:47:57 +0000 yuniar 1332@https://www.machform.com/forums/ <p>This forum can't display backtick properly. So if the above query give you an error, try to copy this one: <a href="http://mf.pastebin.com/f7fcdbcc2" rel="nofollow">http://mf.pastebin.com/f7fcdbcc2</a> </p> https://www.machform.com/forums/topic/drop-downs-and-mysql#post-1331 Fri, 11 Apr 2008 06:45:10 +0000 yuniar 1331@https://www.machform.com/forums/ <p>Hi Molina,</p> <p>Actually, those A and B are just alias for those tables.<br /> In your case, the query would be more complex, since you have two dropdowns.</p> <p>Ok, let say you have table <strong>ap_form_271</strong><br /> element_1 to element_5 are textfields and element_6 and element_7 are dropdowns.</p> <p>Your query would be like this:</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><code></code><br /> So it uses two joins. One to get the value of your first dropdown and second for the other one. A, B and C are just table alias, so you can use it as is.<br /> You only need to change the <strong>271</strong> values. </p> https://www.machform.com/forums/topic/drop-downs-and-mysql#post-1325 Thu, 10 Apr 2008 14:45:19 +0000 Molina 1325@https://www.machform.com/forums/ <p>Hi Yuniar,</p> <p>I bought your software one week ago and I like it a lot, it's easy to use and the forms look very well! Now I'd like to read the data to show them on a webpage and I got a problem that has to do with the drop downs and multiple choices. How can I output them?<br /> 5 months ago, grg had a similar problem (forum topic: Mysql Question) and you answered, that one has to join the 2 tables, ap_form_XX and ap_element_options. This is basically clear; in your sample you wrote:</p> <p>select<br /> A.*,B.option<br /> from<br /> ap_form_99 A left join ap_element_options B<br /> on<br /> A.element_2=B.option_id and B.element_id=2<br /> where<br /> B.form_id=99</p> <p>but what is "select A.*, B.option"?<br /> Let's say I got some elements_1 to elements_5 as textfields, numbers or whatever, which are working very well, and element_6, element_7 in ap_form_XX as drop downs and option_id and option in ap_element_options - but no A and B, for sure ;-)<br /> I'm not very experienced in MySQL, so at the moment I don't have a clue, please give me hint! What do I have to write in the lines SELECT and FROM?</p> <p>Much thanks in advance<br /> Molina </p>