[SOLVED] Quick Question

[paulman888888]

This is the code for my view scores

<?php
// Get sort method
$sort = isset($_GET['order']) ? mysql_real_escape_string($_GET['order']) : 'score';
// Get all the data from the "myscore2" table
$result = mysql_query("SELECT * FROM myscore2 ORDER BY `{$sort}` DESC");
//the rest is not important

How could i add a AESC or DESC link

[revraz]

I think you've used your allotment for the different posts with the same title today.

 

And why don't you just reply with that question in the thread that gave you that code?

[craygo]

Could just add another form field asking the user. and use the same type of code you used for the sort

 

Ray

[The Little Guy]

use a get, and send it ASC or DESC

 

$sort = $_GET['sort'];
$query = 'SELECT * FROM myscore2 ';
switch($sort){
    case 'ASC':
        $query .= 'ORDER BY score ASC';
    break;
    case 'DESC':
        $query .= 'ORDER BY score DESC';
    break;
}
$sql = mysql_query($query);