https://www.machform.com/forums/ MachForm Community Forums Topic: Querying machform database en Wed, 06 May 2026 11:16:52 +0000 https://www.machform.com/forums/topic/querying-machform-database#post-6876 Sat, 08 Aug 2009 09:33:46 +0000 redityo 6876@https://www.machform.com/forums/ <p>ok .. I got your mail, let's continue there </p> https://www.machform.com/forums/topic/querying-machform-database#post-6874 Sat, 08 Aug 2009 02:24:27 +0000 isak 6874@https://www.machform.com/forums/ <p>Just sent the info. Many gracias. </p> https://www.machform.com/forums/topic/querying-machform-database#post-6865 Fri, 07 Aug 2009 13:01:18 +0000 redityo 6865@https://www.machform.com/forums/ <p>Hmmm .. I think the code should works, anyway could you send me your FTP login info and the form url to :</p> <p>customer.service[at]appnitro.com</p> <p>i will help you with the SQL </p> https://www.machform.com/forums/topic/querying-machform-database#post-6863 Fri, 07 Aug 2009 10:34:40 +0000 mattbontrager 6863@https://www.machform.com/forums/ <p>I'm having the same problem.<br /> I pasted the above sql text directly in (changing the element_#'s of course) and...NADA. Seriously... is there not an easier way to do this? I've been struggling with this for so long. It would seem that the point of having forms that submit to databases would only be useful if you could render that data in a customized, relevant way.</p> <p>I was so happy when I discovered this application because it seems geared toward people who like to spend they're time using it... not learning it / learning programming. Please help me. </p> https://www.machform.com/forums/topic/querying-machform-database#post-6858 Thu, 06 Aug 2009 20:58:35 +0000 redityo 6858@https://www.machform.com/forums/ <p>Hmmm ... from your SQL, I assume your form id = 2 and you have 2 drop down (options) field, that are :</p> <p>- element 13<br /> - element 14</p> <p>Then try to Query machform data with these SQL </p> <pre><code>select A.*, B.option as element_13_value, C.option as element_14_value from (ap_form_2 as A left join ap_element_options as B on A.element_13=B.option_id and B.element_id=13 and B.form_id = 2) left join ap_element_options as C on A.element_14=C.option_id and C.element_id=14 and C.form_id=2</code></pre> https://www.machform.com/forums/topic/querying-machform-database#post-6852 Thu, 06 Aug 2009 10:30:28 +0000 isak 6852@https://www.machform.com/forums/ <p>Please help... I cannot get this to work. I have tried both options and they seem to pull from the correct column in my database, but the info is the same in each result whereas in the database it is different. If you go to this link: <a href="http://pdgrafiks.com/results.php" rel="nofollow">http://pdgrafiks.com/results.php</a> you will see that the Property Type and the Office are the same in each row when in the database the values are all different.</p> <p>Here are the codes I have used:</p> <p>SELECT A.*,<br /> B.option AS element_13_value,<br /> C.option AS element_14_value<br /> FROM<br /> (ap_form_2 AS A<br /> LEFT JOIN ap_element_options AS B<br /> ON A.element_13=1 AND B.element_id=13 AND B.option_id=1 and B.form_id=2)<br /> LEFT JOIN ap_element_options AS C<br /> ON A.element_14=1 AND C.element_id=14 AND C.option_id=2 and C.form_id=2</p> <p>........<br /> SELECT A.*,B.option<br /> FROM<br /> ap_form_2 A left join ap_element_options B<br /> on<br /> A.element_13=B.option_id and B.element_id=13<br /> WHERE<br /> B.form_id=2</p> <p>I have tried all I know. Please help. </p> https://www.machform.com/forums/topic/querying-machform-database#post-6834 Wed, 05 Aug 2009 03:20:40 +0000 isak 6834@https://www.machform.com/forums/ <p>I tried both examples you gave me for pulling the value of a dropdown into a search results page and they worked. However, I am pulling several records into the search results. The value being placed in the results page is the value of the first record only when the value for each record in my test is different.</p> <p>If you go to this link: <a href="http://pdgrafiks.com/results.php" rel="nofollow">http://pdgrafiks.com/results.php</a> you will see that the Property Type and the Office are the same in each row when in the database the values are all different.</p> <p>Help? </p> https://www.machform.com/forums/topic/querying-machform-database#post-6817 Tue, 04 Aug 2009 00:48:37 +0000 isak 6817@https://www.machform.com/forums/ <p>Many gracias!! </p> https://www.machform.com/forums/topic/querying-machform-database#post-6803 Mon, 03 Aug 2009 08:31:41 +0000 redityo 6803@https://www.machform.com/forums/ <p>Hello,</p> <p>machform use 'ap_form_x' (x is your form ID) table to store the data, You can simply use this SQL to retrieve machform data :</p> <pre><code>select element_1,element_2 from ap_form_3</code></pre> <p>that SQL will return element 1 and 2 data from form 3. If you need to populate an option field type, you can refer to this 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> <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> https://www.machform.com/forums/topic/querying-machform-database#post-6773 Sat, 01 Aug 2009 02:40:23 +0000 isak 6773@https://www.machform.com/forums/ <p>Can someone point me in the right direction for querying info from the database created by machforms? I need a way to create a link that will pull certain fields into a page for one use and other fields for another use. Help? </p>