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

Add weeks in a query?
I have a SQL that summarizes the quantity per week. The weeks that has no value does not exist in th

Display a default image
I am trying to display generic image for items that don't have one, but I can't get it to display.

Email logic not working
I would like to send an email using the php email() function then if it does execute i.e sends i wou

Word Trimming
Hi Guys & Gals!!

Hope you are all ok....

I need some help with the following

Captcha problem users just refresh and it will let them auto submit again
Users will just re submit and not have to enter the new captcha.. ? Lol but if i refresh the page, t

Database 'Validation'
Hi everyone,
I'm trying to validate the password entered by the user with the password in the dat

$_GET problem
Hi all,

Have a bit of a problem with a little piece of code, I am not sure if this should be

Problem with a select distinct
I have a problema with a select distinct, I have the next sql:

select distinct a,b,c,d fr

IIS & NW MII on the same server
Hi,

We're weighing the possibility to run both IIS and MII (NetWeaver) on the same server

Logic question
im wondering what's the best method to do the above list:

it is for alliance @ MMORPG game