About the order by question

Something like this.

Say Www.xxx.com/index.php?id=5&order=zhucetime.

$order =$_get[' order '];
$id =$_get[' id '];


$sqltext = "SELECT * from table where n_pid= '". $id. "' ORDER BY '". $order. "' ASC ';





How do I achieve the first click by ASC sort the second click followed by the Desc sort of continuous cycle switching ah?

How do I achieve the first click by ASC sort the second click followed by the Desc sort of continuous cycle switching ah?

Reply to discussion (solution)

You need to pass the current sort of way

Give a default only, page pass two array variable you sort of field, and way Yes

I mean, the first time I remember, when I sort the second click on ASC, how do I get a desc sort of code? Novice

I write a single condition:

$by 1=$_get[' by1 '];//the sorting conditions of the page such as desc,asc$order=$_get[' order '; $id =$_get[' id '];if (! $by 1) {$sqltext = "select * FROM table where n_pid= ' ". $id." '  Order by '. $order. "'  ASC ";} else{$sqltext = "SELECT * from table where n_pid= '". $id. "'  Order by '. $order. "'  $by 1 ";}

if (!isset ($_session[' direction ')) | | $_session[' direction '] = = ' desc ') {   $_session[' direction '] = ' ASC ';} else{   $_session[' direction '] = ' desc ';} $sql = "SELECT * from table where n_pid= '". $id. "'  ORDER by  ". $order."  . $_session[' direction '];

You need to pass an ascending order parameter more. Change this parameter value with JS at each point.

In addition, you do not have to do any validation of the input filter directly put SQL is very dangerous!

Hehe 5 Floor method is correct .... Do you have something simpler? jquery or something like that. or any other way

Knot stickers ... A flash of the man hehe ....

