https://www.machform.com/forums/ MachForm Community Forums Topic: concantenate two fields to fill another field en Sun, 03 May 2026 23:06:26 +0000 https://www.machform.com/forums/topic/concantenate-two-fields-to-fill-another-field#post-11282 Tue, 25 Jan 2011 15:21:45 +0000 trekmadone2008 11282@https://www.machform.com/forums/ <p>Hello, I tried this and i get the following error :</p> <p>INSERT INTO <code>ap_form_1</code> (element_1,element_2,element_3,ip_address,date_created) VALUES ('2583','5900','code25835900','84.198.91.208','2011-01-25 08:20:09'); Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'element_1,element_2,element_3,ip_ad' at line 1</p> <p>Can you help me ? </p> https://www.machform.com/forums/topic/concantenate-two-fields-to-fill-another-field#post-5819 Tue, 12 May 2009 23:31:05 +0000 redityo 5819@https://www.machform.com/forums/ <p>You need to edit "includes/post-functions.php" file to do this. Let say you have this information :</p> <p>Field "A" element id = 1<br /> Field "B" element id = 2<br /> Field "C" element id = 3<br /> Form id = 53</p> <p>Then go around line 939 ~ 951, you will see this code :</p> <pre><code>foreach ($table_data as $key=&gt;$value){ if($value == &#39;&#39;){ //don&#39;t insert blank entry continue; } $value = mysql_real_escape_string($value); $field_list .= &quot;&lt;code&gt;$key&lt;/code&gt;,&quot;; $field_values .= &quot;&#39;$value&#39;,&quot;; if(!empty($value)){ $has_value = true; } }</code></pre> <p>replace those code with this one </p> <pre><code>$temp = &#39;&#39;; $temp_field_list= &#39;&#39;; $temp_field_values = &#39;&#39;; if($form_id == &#39;53&#39;) { $element_1_data = mysql_real_escape_string(ereg_replace(&#39; &#39;,&#39;&#39;,$table_data[&#39;element_1&#39;])); $element_2_data = mysql_real_escape_string(ereg_replace(&#39; &#39;,&#39;&#39;,$table_data[&#39;element_2&#39;])); if (array_key_exists(&#39;element_3&#39;,$table_data)) { $temp = &#39;code&#39; . $element_1_data . $element_2_data ; } else { $temp = &#39;code&#39; . $element_1_data . $element_2_data ; $temp_field_list = &quot;&lt;code&gt;element_3&lt;/code&gt;,&quot;; $temp_field_values = &quot;&#39;&quot;.$temp.&quot;&#39;,&quot;; } } foreach ($table_data as $key=&gt;$value){ if($value == &#39;&#39; &#38;&#38; ($form_id != &#39;53&#39; &#38;&#38; $key != &#39;element_3&#39;)){ //don&#39;t insert blank entry continue; } $value = mysql_real_escape_string($value); $field_list .= &quot;&lt;code&gt;$key&lt;/code&gt;,&quot;; if ($form_id == &#39;53&#39; &#38;&#38; $key == &#39;element_3&#39;) $field_values .= &quot;&#39;$temp&#39;,&quot;; else $field_values .= &quot;&#39;$value&#39;,&quot;; if(!empty($value)){ $has_value = true; } } if ($form_id == &#39;53&#39; &#38;&#38; $temp_field_values != &#39;&#39;) { $field_list .= $temp_field_list; $field_values .= $temp_field_values; }</code></pre> <p>make sure you adjust form id and element id number with yours. Also it will remove "space" character in field "A" or field "B". </p> https://www.machform.com/forums/topic/concantenate-two-fields-to-fill-another-field#post-5801 Sun, 10 May 2009 23:40:05 +0000 drbobtampa 5801@https://www.machform.com/forums/ <p>Suppose form-user enters text field A= "XYX" and text field B= "123". </p> <p>I want to populate a hidden, administrator-only third field, C, like this:<br /> concatenate("code"+A+B) to yield text field C= "codeXYZ123". </p> <p>What code and which php can I do that in?<br /> As a bonus question, how can I convert "XY Z" into "XYZ) (that is, remove blanks at the same time)?</p> <p>Many thanks! </p>