https://www.machform.com/forums/ MachForm Community Forums Topic: How to Alphabetically sort concat information en Wed, 06 May 2026 11:28:56 +0000 https://www.machform.com/forums/topic/how-to-alphabetically-sort-concat-information#post-12410 Sat, 30 Jul 2011 20:45:54 +0000 Machmail 12410@https://www.machform.com/forums/ <p>I'd like to buy this script, but this solution works? </p> https://www.machform.com/forums/topic/how-to-alphabetically-sort-concat-information#post-8509 Tue, 26 Jan 2010 23:02:37 +0000 redluss 8509@https://www.machform.com/forums/ <p>Thanks for this post - very exciting. </p> <p>I did find one issue in the code - you need to remove the <em> from the top section of code as it's not supposed to be there - it was falsely translated by the help forum.<br /> However, as a novice at PHP, could you post a little more detail as to where the code under "Then change where the query is formed" is supposed to go? I'm having a hard time figuring out where the query should be inserted into the code.</p> <p>Thanks. </p> https://www.machform.com/forums/topic/how-to-alphabetically-sort-concat-information#post-8495 Tue, 26 Jan 2010 02:31:02 +0000 isak 8495@https://www.machform.com/forums/ <p>Can you make this a little clearer? I could definitely use it.</p> <p>I think my problem is in the query section. Maybe I am not setting it up right. Perhaps you could include more of the code for this section so I can see how to add it and where?</p> <p>About the <em> tags -- omit them? Include them? </p> <p>Thanks. </p> https://www.machform.com/forums/topic/how-to-alphabetically-sort-concat-information#post-8351 Sat, 09 Jan 2010 05:59:39 +0000 meltingsand 8351@https://www.machform.com/forums/ <p>I tried to bold my section and it didn't work. Everything between the "<em>" tags is what I changed. </p> https://www.machform.com/forums/topic/how-to-alphabetically-sort-concat-information#post-8350 Sat, 09 Jan 2010 05:49:56 +0000 meltingsand 8350@https://www.machform.com/forums/ <p>I just figured out a way to sort the data, and it is pretty easy. Now I can just click on a column heading to sort that field, and click again to sort in the reverse order. I'll paste my code real quick. I've done some other modifications so I can't give you line numbers since they'll be wrong. I'll paste what I have, and you should be able to find it pretty easily.</p> <p>In file manage_entries.php:</p> <p>Look for this code (I have bolded what I changed):</p> <p> //print table header<br /> foreach ($column_label as $table_header){<br /> if($table_header['name'] == 'id'){<br /> echo '&lt;th scope="col" class="me_action"&gt;'.$table_header['label'].'&lt;/th&gt;';<br /> }elseif ($table_header['name'] == 'row_num'){<br /> echo '&lt;th scope="col" class="me_number"&gt;'.$table_header['label'].'&lt;/th&gt;';<br /> }else{<br /> <code>&lt;em&gt;</code>if ($order == "desc") { $reverse = "asc"; } else { $reverse = "desc";}<br /> if ($sort == $table_header['name']) { $sortid = "sortfield"; } else { $sortid = "sort"; }<br /> echo '&lt;th scope="col" id="'.$sortid.'"&gt;&lt;div&gt;<a href="'.$PHP_SELF.'?id=1&#38;sort='.$table_header['name'].'&#38;order='.$reverse.'">'.$table_header['label'].'</a>&lt;/div&gt;&lt;/th&gt;'; <code>&lt;/em&gt;</code><br /> }</p> <p>then change where the query is formed:</p> <p><code>&lt;em&gt;</code> if (!isset($sort)) $sort="id";<br /> if (!isset($order)) $order="desc";<br /> <code>&lt;/em&gt;</code><br /> $field_list = implode(',',$column_prefs);<br /> <code>&lt;em&gt;</code><br /> $query = "select id,id as row_num,{$field_list} from <code>ap_form_{$form_id}</code> order by $sort $order $limit";<br /> <code>&lt;/em&gt;</code> </p> https://www.machform.com/forums/topic/how-to-alphabetically-sort-concat-information#post-6547 Sat, 11 Jul 2009 13:39:21 +0000 yuniar 6547@https://www.machform.com/forums/ <p>Sorry, I'm afraid there is no easy way to sort the entries yet.<br /> At this moment, you can do this by exporting the entries into excel file and sort it there. </p> https://www.machform.com/forums/topic/how-to-alphabetically-sort-concat-information#post-6529 Thu, 09 Jul 2009 23:29:43 +0000 hareem 6529@https://www.machform.com/forums/ <p>Hello. MachForm is a great product.It saved me a lot of headaches. I would like to know how can i sort my contacts forms info alphabetically.</p> <p>Please help</p> <p>Humble Regards<br /> Hareem Haque </p>