Help Sorting Category

[xsnoboard]

I want to have my link list to be sorted by Category.. etc Category Videos or Pictures... and so that the most recent is at the top and it just shows either pictures or videos


This is my other code I have for sorting.. I would prolly have to add something similiar below this code...

$rt = mysql_query("SELECT * FROM files ORDER BY $sort $order");

 while($filelist_array = mysql_fetch_array($rt)){

[ralph l mayo]

SELECT * FROM files ORDER BY posted DESC

posted is whatever column holds your timestamp, DESC means DESCending, last (most recent) first

[xsnoboard]

but i need it so it only shows the category videos or category pictures in most recent order

[ralph l mayo]

if you're doing one at a time use SELECT * FROM files WHERE category='foo' ORDER BY posted DESC

or if you're doing both (I think, this might not be what you want)
SELECT * FROM files GROUP BY category ORDER BY posted DESC

[xsnoboard]

i still can't seem to figure this out... I want it so it just displays my categories separetly... So they can click videos and it just shows the videos etc.. instead of all of them mixed...

Videos
Pictures
Flash
Articles

[degsy]

$rt = mysql_query("SELECT * FROM files ORDER BY $sort $order");

PHP Code:

<a href="page.asp?cat=Videos&order=DESC">Videos</a>

$cat=$_GET['cat'];
$order=$_GET['order'];

$rt = mysql_query("SELECT * FROM files WHERE category='$cat' ORDER BY name $order"); 


You probably want to do some validation on the variables & query, but that it is basic type of query and hyperlink.