sorting list of data in php?

Question

hi i have an list of countries on table so i am sorting with country name then i get A-Z locations like this Afghanistan, Bangladesh,Cape Verde, Denmark,Equatorial Guinea,Falkland Islands,USA, Yemen , Zambiabut actually i need USA on top (i mean first element) like this order USA,Afghanistan, Bangladesh,Cape Verde, Denmark,Equatorial Guinea,Falkland Islands, Yemen , Zambiahere is my code

<?php
require 'dbconnect.php';
$empty=array();
$c=0;

$query="select * from phpfox_country";
$result=mysql_query($query);

if($result)
{
   while($row=mysql_fetch_row($result))
   {

   if($row[1]=="United States")
   {
   $message=array("country_iso"=>$row[0],"name"=>$row[1])
   }
   else
   {
     $message[$c]=array("country_iso"=>$row[0],"name"=>$row[1]);
   }

     $c++;
   }
  $message=($message==null)?$empty:$message;
}
else
{
$message=array("message"=>"error in code");
}
echo json_encode($message);
?>

thanks for advance.

Shakti Singh · Accepted Answer · 2012-02-10 08:24:12Z

2

Why not just do with mysql query

SELECT * FROM phpfox_country 
         ORDER BY IF (countryName !='USA',countryName,'' ) ASC

answered Feb 10, 2012 at 8:24

Shakti Singh

86.7k21 gold badges142 silver badges156 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Feysal · Accepted Answer · 2012-02-10 08:54:42Z

Looks like there are some errors in your code. First, by setting $c to 0 by default and using that as an array index you are assigning the alphabetically first country to that slot, not USA. Worse still, when you actually reach the row with USA on it, you don't add it to the existing array, instead you overwrite the array by assigning a new array.

I suggest that you don't use $c at all. Instead start with an empty array, add USA to the front of the array, and all other countries to the end of the array. As for arranging the records, that is easiest to do with the SQL query. The below code assumes the column with the country name is called name - if it is not, you can fix this yourself.

<?php
require 'dbconnect.php';
// Create empty array
$message=array();

$query="SELECT * FROM phpfox_country ORDER BY name ASC";
$result=mysql_query($query);

if($result)
{
    while($row=mysql_fetch_row($result))
    {
        if($row[1]=="United States")
        {
            // Add to start of the array
            array_unshift($message, array("country_iso"=>$row[0],"name"=>$row[1]));
        }
        else
        {
            // Add to end of the array
            $message[]=array("country_iso"=>$row[0],"name"=>$row[1]);
        }
    }
}
else
{
    $message=array("message"=>"error in code");
}
echo json_encode($message);
?>

Supr · Accepted Answer · 2012-02-10 08:24:37Z

0

One way is to reserve a place in the beginning of the array:

<?php
require 'dbconnect.php';
$message=array(0 => 'placeholder');

$query="select * from phpfox_country";
$result=mysql_query($query);

if($result)
{
   while($row=mysql_fetch_row($result))
   {

     if($row[1]=="United States")
     {
       $message[0]=array("country_iso"=>$row[0],"name"=>$row[1])
     }
     else
     {
       $message[]=array("country_iso"=>$row[0],"name"=>$row[1]);
     }

     $c++;
   }
}
else
{
  $message=array("message"=>"error in code");
}

echo json_encode($message);
?>

answered Feb 10, 2012 at 8:24

Supr

19.1k3 gold badges33 silver badges37 bronze badges

Comments

Timur · Accepted Answer · 2012-02-10 08:27:47Z

0

Modify your query and code like this:

<?php
require 'dbconnect.php';

$query = "select * from phpfox_country order by <country_name>='USA' DESC,<country_name>";
$result=mysql_query($query);

if($result)
{
    $message = array();
    while( false!==($row=mysql_fetch_row($result)) )
    {
        $message[] = array("country_iso"=>$row[0],"name"=>$row[1])
    }
}
else
{
    $message=array("message"=>"error in code");
}
echo json_encode($message);
?>

But not forget to replace <country_name> with country's name column

answered Feb 10, 2012 at 8:27

Timur

6,7381 gold badge30 silver badges37 bronze badges

Collectives™ on Stack Overflow

sorting list of data in php?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related