Sorting with PHP and HTML

[srmurthy]

I was trying to do a sort on a result set for an HTML page.

http://www.autoradiocenter.com/products/products_result.php3?cat_name=CD+Players

I wanted to sort by Company, or Model, or Price, etc. But I keep getting errors. I tried putting a select statment within the HREF tag, maybe I am just doing soething wrong. Something anyone here can help me out on?

Thanks

[Anon]

Hello,

Maybe you can do this:

< a h r e f = "<?= $PHP_SELF; ?>?sort=Place">Here< / a >

in the same page where the sql call is:

SELECT * FROM whatever WHERE id='blah' SORT BY $sort;

Should do it.

Bill