Showing selected item at top of list

Posted on 16th Feb 2014 07:03 pm by admin

Hi,

I've got a list of names which i am fetching from database like this:
$qry = db_query("SELECT * FROM names");



$i=1;

//prepair list

$html .= '<ul><li>';

while($list = db_fetch_object($qry)){



$html .= '<a>'.$list->name.'</a><div style="height:0px;"></div>';

if($i%6==0){



$html .='</li><li>';

}

$i++;

}

$html .='</li></ul>';

return $html;
Clicking on a name displays its details on next page.
Now my requirement is that i want to display the selected record on next page at the top of the list and rest coming after this record.

I am not getting a way to achieve this!

Please suggest me someway of doing this!
Thanks

Your Answer:

Login to answer

Other forums

Is there a function ... auto send IP
Is there some function that can be sent to a ddns service that returns the ip address of a ddns forw

Share admin accross websites
I'm using .net memberships and roles in one of my sites, but I need to be able to share logins and p

images aren't rendering
I'm trying to call a JPG file from within PHP (in an effort to hide the actual JPG folder). The imag

ob_ dynamic content
i was wondering about the potential to use ob to create a <div then remove it when the page

php require help needed
Ok i tried to use the search funtion but the word require is everywhere.

i'm really new to cr

Help building / using array
First - this is a cross-posting, if this is wrong I apologise! What started out as a MySQL query que

my sql select id and then update problem.
I need to select some auto incremented ids out of a database and then use those id in a where statem

email form (cannot find the problem)
Hello there. I've been having trouble with an email form. Can't find the problem really. I've tested

Strip Slashes Help
I've got a script that i've downloaded of the net to edit multiple fields from my sql database, and

Big O & time complexity ???
can you help me how to calculate the Big O & time complexity for any algorithm and c++ program pleas