Hiya, I'm trying to sort a database from what a user clicks on. So if they click on "sortbyname" it sorts it by name, and if they click on "sortbydate" it sorts the information by date.

This is what I have so far :
The link clicked on takes them to http://localhost/list.invoice.php?page=date

Then,

PHP Code:

<?php 
echo $WFunctions->listInvoices($_GET['page']);
?>

This pulls what page equals, so for this example its "date"

PHP Code:

function listInvoices($page) { 


Then this gets it.

PHP Code:

$query = mysql_query("SELECT * FROM invoice WHERE filename = '".$element."' ORDER BY $page"); 


And this trys to sort it.


The information is getting sent because I can use

PHP Code:

echo('$user_id'); 


And it prints out what page equals.

It doesn;t sort the data though
Really stuck here :/

print() what is the $page value right before calling this:
$query = mysql_query("SELECT * FROM invoice WHERE filename = '".$element."' ORDER BY $page");

What ever index.php?page='s

So, if its index.php?page=date, it sorts by date
if its index.php?page=name, it sorts by name

But it isnt sorting. or ordering.

SORRY! echo('$user_id'); should be echo('$page');

I don't understand waht do you want to get. What do you think the 'sorting' is and how does it differ from 'ordering'?

ORDER BY

Orders the database information pull. correct?

I want the user to be able to sort the list how ever the wish.

Eg. List A-Z with name
List A-Z, 1-9 with Date

So add one more parameter to your request and also enhance your sql query, something like that:
select * from invoice where filename = '$element' and lalala regexp '[A-z1-9]' order by $page
I thought it is obvious.