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

Undefined variable when using $_SERVER['PHP_SELF']
Hi guyz, please suggest me something...
On first.php I have one input field NAME, and on posting

Please help with SMTP Authenticated PHP Email Form
Hello, I'm creating a PHP email form, and for this particular server, I have to use SMTP Authenticat

Giving the below syntax error
Dear Experts,

I have used 2 buttons in gui status as display and cjhange.When the user wi

Auto install
Hi I have a directory lets say "apps" that I then have more folders ie "email",

how do i make new line after *
First check this page here. and you see my report. Im pulling form a mysql db. I want to beable to m

Table Control
Hi Guru's,

I've created a Module pool program, which contains the Table Control.

how to query data from website using VC?
I want to query some datum from a website,so I need a program to read data from a .csv file, and ass

recrawling
Can anyone suggest me how may i know a page is updated before it is being downloaded, so that i can

Change Age automatically
hi guys . im new to php , is it possible to change age value in mysql automatically when year change

Hits this week counter
I have a counter on my site that tracks hits, IP's, etc. into a mySQL database. It also includes the