Sorting After Explode

[ausge]

I have this query which echos the data in the field CODE
which is like that 1|2|3|4|5 etc
which is the codes ids for each city

$query="select * from vz_cities_tbl where VCI_ID='".$row_Recordset2['city_of_interest']."' ";
$result=mysql_query($query);

if(mysql_num_rows($result)>0)
{
$city=mysql_fetch_array($result);
                    
$topBanners=explode('|',$city['CODE']);
                    
/*print_r($topBanners);
                    
echo "<br />";*/
                    
} 

is there any way to sort the Output Descending ???????????
like
5|4|3|2|1

[ScallioXTX]

Take a look at The different array sorting functions of PHP and use rsort().

$topBanners=explode('|',$city['CODE']);
rsort($topBanners); 

Like it says on the comparison page:

Note: All of these sort functions act directly on the array variable itself, as opposed to returning a new sorted array

[ausge]

yes thank you
but now the problem that its sorting case sensitive
as that the sort function is case sensitive. All capital letters come before all lowercase letters

so is there a way to make it not case sensitive?

and plz am making a sql statement that search using LIKE
but its also case sensitive
like if i search for "Alex" and it was saved as "alex"
it never shows up!!

any idea???

[Kayarc]

http://nl3.php.net/manual/en/function.natcasesort.php

would that work?

[ScallioXTX]

http://nl3.php.net/manual/en/function.natcasesort.php

would that work?

That won't work since natcasesort sorts ascending.

What would work:

$topBanners=explode('|',$city['CODE']);
$topBannersLowercase = array_map('strtolower', $topBanners');

array_multisort($topBannersLowercase, SORT_DESC, SORT_STRING, $topBanners); 

As for the case insensitive LIKE, ever heard of google?