HTML Sorting of a MySQL Table

[w33nie]

What I want is for my MySQL database to be printed on a mostly html based page, with links on the top of each column, saying what information is contained in the columns below.
Then all I want is for these links to be a simple <a> link, but all they do is sort the mySQL table below when clicked.
Is this possible?

example..
<a ????="<?php
$query = mysql_query('SELECT * FROM `stats` ORDER BY number DESC LIMIT 0, 64') ?>">Number</a>
just something like that, simple.

But if it isn't possible, how else could I do it?

[mwasif]

Moved from MySQL to PHP Forum.

[kovik]

What I want is for my MySQL database to be printed on a mostly html based page, with links on the top of each column, saying what information is contained in the columns below.
Then all I want is for these links to be a simple <a> link, but all they do is sort the mySQL table below when clicked.
Is this possible?

example..
<a ????="<?php
$query = mysql_query('SELECT * FROM `stats` ORDER BY number DESC LIMIT 0, 64') ?>">Number</a>
just something like that, simple.

But if it isn't possible, how else could I do it?

I've had someone ask this question to me over at DevNetwork. You can see this simple example I gave here.

[w33nie]

Thanks, I'll post anything further in there.