https://www.machform.com/forums/ MachForm Community Forums Topic: Display issues in queries en Mon, 04 May 2026 03:59:39 +0000 https://www.machform.com/forums/topic/display-issues-in-queries#post-14180 Fri, 30 Mar 2012 04:53:33 +0000 arturom 14180@https://www.machform.com/forums/ <p>Hello Yuniar,</p> <p>I'm sorry, but I'm a complete newbie and don't have much experience with these matters. As far as recreating the download link I looked into "includes/entry-functions.php" file around line 545-581 like you suggested, but I don't know what piece of that code to use. I tried several thing but got error messages. Like this one: Fatal error:<br /> <code>Call to undefined function mf_do_query() in /folder/query.php</code></p> <p>Could you please let me know what code I would need to use in order to create a download link for the query?</p> <p>Once again I thank you for your great support! Kind regards. </p> https://www.machform.com/forums/topic/display-issues-in-queries#post-14173 Fri, 30 Mar 2012 00:40:28 +0000 arturom 14173@https://www.machform.com/forums/ <p>Sorry here's the rest:</p> <p> mysql_query("SET NAMES 'charset=CP1251' ", $conn );<br /> $query = "SELECT * FROM <code>ap_form_2</code> ORDER BY ID DESC LIMIT 1";<br /> $result = mysql_query($query, $conn );</p> <p>if( $result === FALSE ) {<br /> echo '&lt;div class="ERROR"&gt;'.mysql_error().'&lt;/div&gt;';<br /> } else {<br /> while($row = mysql_fetch_array($result))<br /> { </p> https://www.machform.com/forums/topic/display-issues-in-queries#post-14172 Thu, 29 Mar 2012 23:55:10 +0000 arturom 14172@https://www.machform.com/forums/ <p>Thank you very much Yuniar,</p> <p>1) This is the line that displays the date: &lt;div id=\"fecha\"&gt;" . utf8_encode($row["element_9"]). "&lt;/div&gt;</p> <p>Also, thank you for your comments on the other two issues. I'll look into that!</p> <p>Kind regards. </p> https://www.machform.com/forums/topic/display-issues-in-queries#post-14166 Thu, 29 Mar 2012 21:22:22 +0000 yuniar 14166@https://www.machform.com/forums/ <p>1) You can use the date_format() function on your query. Can you let me know your query?</p> <p>2) Those are the index of the dropdown. To get the actual values, you will need to do a lookup into "ap_element_options" table. You can do a JOIN query for this. You might want to check this post below for some sample:<br /> <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>3) You will need to construct the download link again, using the same method as MachForm does. You can look into "includes/entry-functions.php" file around line 545-581. You'll find the code there. </p> https://www.machform.com/forums/topic/display-issues-in-queries#post-14147 Wed, 28 Mar 2012 23:08:20 +0000 arturom 14147@https://www.machform.com/forums/ <p>Hello, </p> <p>Awesome software!!</p> <p>I have a couple of questions concerning queries I'm running from MachForm.</p> <p>I'm doing this simple query:</p> <p>echo "&lt;div id=\"Actirightcolumn\"&gt;<br /> &lt;div id=\"fecha\"&gt;" . utf8_encode($row["element_9"]). "&lt;/div&gt;<br /> &lt;div id=\"actititle\"&gt;" . utf8_encode($row["element_1"]). "&lt;/div&gt;<br /> &lt;div id=\"actititle\"&gt;" . utf8_encode($row["element_2"]). "&lt;/div&gt;<br /> &lt;div id=\"actititle\"&gt;" . utf8_encode($row["element_3"]). "(Tipo de archivo)&lt;/div&gt;<br /> &lt;div id=\"actititle\"&gt;" . utf8_encode($row["element_4"]). "&lt;/div&gt;<br /> &lt;div id=\"actides\"&gt;" . utf8_encode($row["element_5"]). " &lt;span id=\"moreinfo\"&gt;<a title='Ver más' href='".utf8_encode($row["element_8"])."'>VER MÁS</a>&lt;/span&gt; &lt;/div&gt;<br /> &lt;/div&gt;";</p> <p>1. "element_9" is the date. But it's showing up like: 2012-03-28 instead of 28-03-2012 (DD-MM-YYYY) which is the date format I selected on the backend for this field. How can I have it show up in this format (DD-MM-YYYY)?</p> <p>2. "element_3" is a drop-down where user selects the type of file being uploaded (PDF, DOC, JPG, etc). This particular query shows a number,<br /> like: 1, 2, 3 rather than the name of the type of file indicated in the form. So, how can I get it to display: PDF, DOC, JPG, etc. instead of: 1, 2, 3, etc.?</p> <p>3. I'm having users upload files using the forms and it's working great. On the display (query) page I need to add an option to allow users to "download" files. What would you recommend I do for that?</p> <p>Thank you very much for your excellent support! </p>