MySQL Query Help

Domains4u · 02-14-2006, 06:26 AM

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?

Code:

$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 · 02-14-2006, 07:07 AM

try:

PHP Code:

  $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 · 02-14-2006, 07:31 AM

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

02-14-2006, 06:26 AM	#1 (permalink)
Domains4u Account Suspended Join Date: Nov 2005 Location: www.TFFH.net Posts: 280 58.80 NP$ (Donate)	MySQL Query Help 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? Code: $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);

02-14-2006, 07:07 AM	#2 (permalink)
moondog NamePros Regular Join Date: Jun 2004 Posts: 476 3,677.00 NP$ (Donate)	try: PHP Code: `$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";` __________________ The mass purge has begun.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Great Scripts for Sale With Resale Rights!	Zeeble	Scripts For Sale	20	01-04-2006 01:39 AM
MySQL Tips	shahid_146	Webmaster Tutorials	4	10-18-2005 12:53 PM
Tutorial: How to Install Apache2 MySQL and PHP on Windows	deadserious	Webmaster Tutorials	35	09-21-2005 09:46 PM
Tutorial: Getting Started With MySQL (The Basics)	deadserious	Webmaster Tutorials	3	04-18-2004 01:17 PM

02-14-2006, 07:31 AM	#3 (permalink)
imMike Account Closed Join Date: Feb 2006 Posts: 42 0.00 NP$ (Donate)	What he said. Change ASC (ascending order) to DESC (descending order) in your query.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)