pepelepew1962 Posted October 10, 2011 Share Posted October 10, 2011 Hello: When I call up a specific record, I need to sort the contents of "tblpartmanuf" and replace that field with the sorted information. Lets say the record is: tblpartnumber tblpartmanuf 12544 GFSD After I edit some other fields, automatically sort the tblpartmanuf field so that it is: 12544 DFGS $sql="SELECT tblpartnumber, tblpartmanuf FROM tblparts WHERE tblpartnumber ='$frmpartfinder'"; $result = mysql_query($sql) or die('Error: ' . mysql_error()); Link to comment https://forums.phpfreaks.com/topic/248819-sort-the-contents-for-a-record-field/ Share on other sites More sharing options...
fenway Posted October 10, 2011 Share Posted October 10, 2011 That doesn't make any sense -- try again. Link to comment https://forums.phpfreaks.com/topic/248819-sort-the-contents-for-a-record-field/#findComment-1277917 Share on other sites More sharing options...
awjudd Posted October 11, 2011 Share Posted October 11, 2011 I'm guessing you want to order the letters stored in a text field in the database. Is this correct? If yes, the fields aren't meant to work that way. ~juddster Link to comment https://forums.phpfreaks.com/topic/248819-sort-the-contents-for-a-record-field/#findComment-1278008 Share on other sites More sharing options...
fenway Posted October 11, 2011 Share Posted October 11, 2011 If that's what you want, just sort the string yourself before you insert into Link to comment https://forums.phpfreaks.com/topic/248819-sort-the-contents-for-a-record-field/#findComment-1278222 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.