By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,460 Members | 1,193 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,460 IT Pros & Developers. It's quick & easy.

HTML Sorting of a MySQL Table

w33nie
P: 56
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?
Jul 29 '07 #1
Share this Question
Share on Google+
3 Replies


mwasif
Expert 100+
P: 801
Moved from MySQL to PHP Forum.
Jul 29 '07 #2

kovik
Expert 100+
P: 1,044
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.
Jul 29 '07 #3

w33nie
P: 56
Thanks, I'll post anything further in there.
Jul 31 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.