https://www.machform.com/forums/ MachForm Community Forums Topic: Display problem in queries en Mon, 04 May 2026 03:52:45 +0000 https://www.machform.com/forums/topic/display-problem-in-queries#post-14972 Wed, 06 Jun 2012 04:13:12 +0000 arturom 14972@https://www.machform.com/forums/ <p>I never received a reply for this, but thankfully it's solved now. Regards. </p> https://www.machform.com/forums/topic/display-problem-in-queries#post-14928 Wed, 30 May 2012 08:05:06 +0000 arturom 14928@https://www.machform.com/forums/ <p>Hello,</p> <p>I love your software! But I'm having problems concerning queries I'm running from MachForm.</p> <p>I'm running this query which can be viewed on this link: <a href="http://70.87.90.196/~visionmu/Oficina_Costa_Rica.php." rel="nofollow">http://70.87.90.196/~visionmu/Oficina_Costa_Rica.php.</a> Here's the query:</p> <pre><code>&lt;?php mysql_query(&quot;SET NAMES &#39;charset=CP1251&#39; &quot;, $conn ); $query = &quot;SELECT * FROM &lt;code&gt;ap_form_1&lt;/code&gt; INNER JOIN &lt;code&gt;ap_element_options&lt;/code&gt; ORDER BY ID DESC LIMIT 5&quot;; $result = mysql_query($query, $conn ); if( $result === FALSE ) { echo &#39;&lt;div class=&quot;ERROR&quot;&gt;&#39;.mysql_error().&#39;&lt;/div&gt;&#39;; } else { while($row = mysql_fetch_array($result)) { echo &quot;&lt;div id=\&quot;bloque\&quot;&gt; &lt;div id=\&quot;fecha\&quot;&gt;&quot; . utf8_encode($row[&quot;element_1&quot;]). &quot;&lt;/div&gt; &lt;div id=\&quot;actititle\&quot;&gt;&quot; . utf8_encode($row[&quot;element_3&quot;]). &quot;&lt;/div&gt; &lt;div id=\&quot;actititle\&quot;&gt;&quot; . utf8_encode($row[&quot;element_5&quot;]). &quot;&lt;/div&gt; &lt;div id=\&quot;actititle\&quot;&gt;&quot; . utf8_encode($row[&quot;option&quot;]). &quot;(Tipo de archivo)&lt;/div&gt; &lt;div id=\&quot;actititle\&quot;&gt;&quot; . utf8_encode($row[&quot;element_6&quot;]). &quot;&lt;/div&gt; &quot;; } } ?&gt;</code></pre> <p>1. "option" is intended to display the type of file as entered in the form. (PDF, DOC, JPG, etc). For some reason on the query page, each query displays each of the file types and not the one that corresponds. I mean, instead of showing each query's actual file type it seems to randomly select a file type. </p> <p>2. For some reason, instead of displaying the last five records (as it should), the query is displaying the same record five times. I don't know why!</p> <p>Thank you very much for your excellent support! </p>