MachForm Community Forums » MachForm 3

1. arturom
   Member

   Hello,

   I love your software! But I'm having problems concerning queries I'm running from MachForm.

   I'm running this query which can be viewed on this link: http://70.87.90.196/~visionmu/Oficina_Costa_Rica.php. Here's the query:

   <?php
   	   mysql_query("SET NAMES 'charset=CP1251' ", $conn );
   $query = "SELECT * FROM <code>ap_form_1</code> INNER JOIN <code>ap_element_options</code>  ORDER BY ID DESC LIMIT 5";
   $result = mysql_query($query, $conn );	   
   
   	    if( $result === FALSE ) {
     echo '<div class="ERROR">'.mysql_error().'</div>';
   } else {
   while($row = mysql_fetch_array($result))
   {
   
   echo "<div id=\"bloque\">
   <div id=\"fecha\">" . utf8_encode($row["element_1"]). "</div>
   <div id=\"actititle\">" . utf8_encode($row["element_3"]). "</div>
   <div id=\"actititle\">" . utf8_encode($row["element_5"]). "</div>
   <div id=\"actititle\">" . utf8_encode($row["option"]). "(Tipo de archivo)</div>
   <div id=\"actititle\">" . utf8_encode($row["element_6"]). "</div>
   ";
   
   }
   }
   
   ?>

   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.

   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!

   Thank you very much for your excellent support!

   Posted 12 years ago #

2. arturom
   Member

   I never received a reply for this, but thankfully it's solved now. Regards.

   Posted 12 years ago #

RSS feed for this topic

Reply

You must log in to post.