SELECT * FROM mytable ORDER BY series,price;
-Original Message-
From: René Fournier [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001 4:27 PM
To: [EMAIL PROTECTED]
Subject: MySQL ORDER BY or PHP Sort?
I want to select about 25 rows from a table, and sort them by two
Don't forget LIMIT 0,25 (I want to select about 25 rows from a table...)
SELECT * FROM mytable ORDER BY series,price LIMIT 0,25
Mike
Rick Emery wrote:
SELECT * FROM mytable ORDER BY series,price;
-Original Message-
From: René Fournier [mailto:[EMAIL PROTECTED]]
Sent: Monday,
From: René Fournier [EMAIL PROTECTED]
Date: Mon Dec 03, 2001 06:11:23 PM US/Mountain
To: Benjamin Pflugmann [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED] [EMAIL PROTECTED]
Subject: Re: MySQL ORDER BY or PHP Sort? Oops.
Here is the snippet of code that is presenting a challenge
]
Subject: [PHP] Re: MySQL ORDER BY or PHP Sort? Oops.
From: René Fournier [EMAIL PROTECTED]
Date: Mon Dec 03, 2001 06:11:23 PM US/Mountain
To: Benjamin Pflugmann [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED] [EMAIL PROTECTED]
Subject: Re: MySQL ORDER BY or PHP Sort? Oops.
Here is the snippet of code
-Original Message-
From: René Fournier [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 04, 2001 12:16 PM
To: Benjamin Pflugmann; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP] Re: MySQL ORDER BY or PHP Sort? Oops.
From: René Fournier [EMAIL PROTECTED]
Date: Mon Dec 03, 2001
5 matches
Mail list logo