Hi all,
I am a php rookie. I like to get a PHP function returning an array which gets a string(search query) and db results(an array) as arguments. This array should be sorted in ascending (alphabetical) order with search query positions.
I tried of querying the results but i struck up with sorting with search query positioning.
My db Array()
{
Hussain,Dalton,Zaheerus,beltwood,usher,johnny,walker,
}
My snippet

function getSearchRecords  ($string){
         $listRecords=array();

        $query="select name,member_id from member_details where name like '%$string%' order by name";
        $queryResult =  self::DbExecuteQuery($query);
        while($getRecords = self::DbFetchAssoc($queryResult)){
			array_push($listRecords,$getRecords);
			}
	return $listRecords;

$string="us";
will return hussain,usher,zaheerus (in this order).
but i need this function to return
usher [position of search query is at first]
Hussain
zaheerus[position of search query is at last]

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.