[rani]

hi ALL,

i have list of 3 things listed in the brower.
the output looks like this
------+-----+-----+
|field 1 | field2 | field3 | header
+------+-----+-----+

if i click in any of the header
eg. feild 1 the the list arraged in asc order,if click once again then it arragesin descending order..
now i want to add an arrow in the header depending on
what order it arranged.
can anyone help me out .
i have written the code in php..
thanks
rani

[NeverMind]

the link (URL) of each of these should contain something like order=desc or asc ..
e.g. field 1 link gotta be something like this:

Code:

<a href="field1.php?order=DESC">Field 1</a>

now have something in your php code that will look for the order wanted..
as for the arrow issue, just see if order is ASC for example then the image is arrowasc.gif or what ever .. and example will help..

PHP Code:

if (isset($_GET['order'])) {

  $order = $_GET['order'];



  if ($order == 'DESC') {

    $image = 'arrowup.jpg';



//DO DESC THE SORTING HERE ..



  } elseif ($order == 'ASC') {

    $image = 'arrowdown.jpg';



//DO ASC SORTING HERE



  }

}



//this is how to output the image .

echo '<img src="images/'.$image.'" />'; 

hope that helps

[rani]

yes i could do till here,but i have one problem..
when the page is intially loaded,

[ i am also passing the header name (field name eg field1 be name)
if field name is not passed then to mysql query default fieldname will be name with the intial conditon to sort as asc.
feildname=name sort =asc
eg: select * from tablename oderby fieldname sort;]
when the page loads the arrow shd not come in any header. fine till here i could do,but i have limited the number of rows to be 40, if it is more then it goes to second page..
here it the prb,when it goes to 2nd page the arrow shows up in name field wh i don't want..
otherwise i managed to show only to header wh user click..but the intial conditon with 2nd page is the problem can someone help here.

Originally Posted by NeverMind

the link (URL) of each of these should contain something like order=desc or asc ..
e.g. field 1 link gotta be something like this:

Code:

<a href="field1.php?order=DESC">Field 1</a>

now have something in your php code that will look for the order wanted..
as for the arrow issue, just see if order is ASC for example then the image is arrowasc.gif or what ever .. and example will help..

PHP Code:

if (isset($_GET['order'])) {

  $order = $_GET['order'];



  if ($order == 'DESC') {

    $image = 'arrowup.jpg';



//DO DESC THE SORTING HERE ..



  } elseif ($order == 'ASC') {

    $image = 'arrowdown.jpg';



//DO ASC SORTING HERE



  }

}



//this is how to output the image .

echo '<img src="images/'.$image.'" />'; 

hope that helps

[rani]

yes i could do till here,but i have one problem..
when the page is intially loaded,
the up or down arrow was displayed,which i figured out.
thanks

Originally Posted by NeverMind

the link (URL) of each of these should contain something like order=desc or asc ..
e.g. field 1 link gotta be something like this:

Code:

<a href="field1.php?order=DESC">Field 1</a>

now have something in your php code that will look for the order wanted..
as for the arrow issue, just see if order is ASC for example then the image is arrowasc.gif or what ever .. and example will help..

PHP Code:

if (isset($_GET['order'])) {

  $order = $_GET['order'];



  if ($order == 'DESC') {

    $image = 'arrowup.jpg';



//DO DESC THE SORTING HERE ..



  } elseif ($order == 'ASC') {

    $image = 'arrowdown.jpg';



//DO ASC SORTING HERE



  }

}



//this is how to output the image .

echo '<img src="images/'.$image.'" />'; 

hope that helps