MySQL Query Help

[Domains4u]

Hi there.

Ive got a databse running and an admin panel so i can add data. The data is displayed in a table.

When i add new data the new data ends up at the bottom of the post. Check www.UKGMC.com for an example.

Heres the code im using. How would i change it to display the newest data at the top?

$query = "SELECT CONCAT(dl_genre) AS genre, (dl_name) AS name, (dl_desc) AS dr, (dl_date) AS cat, (dl_link) AS link 
FROM dl ORDER BY dl_id ASC"; 
$result = @mysql_query ($query);

 

[moondog]

try:

$query = "SELECT CONCAT(dl_genre) AS genre, (dl_name) AS name, (dl_desc) AS dr, (dl_date) AS cat, (dl_link) AS link 
FROM dl ORDER BY dl_id DESC";

 

[imMike]

What he said. Change ASC (ascending order) to DESC (descending order) in your query.