sorting the contents on a record field ... - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

pepe_lepew1962 · 10-10-2011, 01:20 PM

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

yourluxurygucci · 11-10-2011, 10:16 PM

i like to read informative blogs and this blog is also so good and helpful.

PradeepKr · 11-25-2011, 10:58 AM

doing it in single shot is very difficult (at least to me).
You better grab that into PHP variable and then break the string into single letters, sort them, join them and send them back to DB.

PradeepKr · 11-25-2011, 11:14 AM

Try this,

PHP Code:


			
<?php 



$sql="SELECT tblpartnumber, tblpartmanuf FROM tblparts WHERE tblpartnumber ='$frmpartfinder'";

$result = mysql_query($sql) or die('Error: ' . mysql_error());

while($row = mysql_fetch_array($result))

{

  //$letters = explode ('', $row['tblpartmanuf']);

  $letters = str_split(row['tblpartmanuf']);

  sort($letters);

  $letters = implode('', $letters) ;



  $sql="UPDATE TABLE tblparts SET tblpartmanuf = '$letters' WHERE tblpartnumber ='$frmpartfinder'";

  $result = mysql_query($sql) or die('Error: ' . mysql_error());

  

  if(mysql_affected_rows()>0)

  {

    echo 'Updated successfully.';

  } 

  else

  {

    echo 'Failed to update';

  }

}



?>