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

Getting Subdomain Name With PHP?
I want to grab the subdomain name with PHP so I can generate database queries.

for example my

Fetching array then reversing it
Hi, I have a simple problem, I'll try to explain it as best I can:
News entries in my database ar

TCP Sending Unsigned Char...
Hi...

I want to send over tcp/ip some data, i have the data in hexadecimal, and when i tr

PHP & Images [Resize, Crop, Save]
Hey! Well I have a little dilema, hoping I could find some guidance.

I have a CMS and on the

Multiple upload and Resize
I would like some help on my script I have the for my index.php

////

<html&

Namespace Problem
I'm having problem with a section of code with a variable namespace.

This code works fine:

Putting double spaces instead of single spaces
Im looking at trying to replace all single spacing between fields with double spacing

At pres

array_count_values question?
ok i'm trying to create a top ten list from a database of listed favorite movies.

the followi

admin with my register system?
Hey i wana make it so i can make a admin level on my register system , I'm kinda new to php to im no

Quick variable question
hey guys/gals,
im trying to write a php script and it works fine as i have it, but i need to set