sort the contents for a record field ...

[pepelepew1962]

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());

[fenway]

That doesn't make any sense -- try again.

[awjudd]

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

[fenway]

If that's what you want, just sort the string yourself before you insert into