RE: [PHP] Re: mysql ORDER BY problem

> Sent: Sunday, June 18, 2006 4:51 PM > Subject: [PHP] Re: mysql ORDER BY problem > > >> On Sun, 18 Jun 2006 15:55:14 -0500, Rob W. wrote: >> >>> >>> Is there a way with my mysql query so that I can list the numbers in >>> correct order? >>

Re: [PHP] Re: mysql ORDER BY problem

syntax, or ask on the MySQL list. You want PHP to do the sorting, look at PHP's array functions; however, it'd be more efficient to go the MySQL route. - Original Message - From: "Michael Rasmussen" <[EMAIL PROTECTED]> To: Sent: Sunday, June 18, 2006 4:51 PM

Re: [PHP] Re: mysql ORDER BY problem

It's not in general to mysql, it's how php and mysql is displaying it. - Original Message - From: "Michael Rasmussen" <[EMAIL PROTECTED]> To: Sent: Sunday, June 18, 2006 4:51 PM Subject: [PHP] Re: mysql ORDER BY problem On Sun, 18 Jun 2006 15:55:14 -0500,

[PHP] Re: mysql ORDER BY problem

On Sun, 18 Jun 2006 15:55:14 -0500, Rob W. wrote: > > Is there a way with my mysql query so that I can list the numbers in > correct order? > In what way is this problem related to PHP? Try a MySQL group instead. -- Hilsen/Regards Michael Rasmussen http://keyserver.veridis.com:11371/pks/lookup

RE: [PHP] Re: MySQL: Order by

make your column of type int column -Original Message- From: Ben Ramsey [mailto:[EMAIL PROTECTED] Sent: Thursday, February 05, 2004 7:52 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP] Re: MySQL: Order by I assume "number" is a column name in your table. If so

[PHP] Re: MySQL: Order by

I assume "number" is a column name in your table. If so, I'm also guessing that it's probably of a varchar (or some other character type) datatype. Here's why: if it's a character, then ORDER BY will sort alphabetically. The way it sorts number alphabetically is rather odd, but it makes sens

Re: [PHP] Re: MySQL ORDER BY or PHP Sort? Oops.

t > on that? > > otherwise you'll have to use php > > -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: MySQ

RE: [PHP] Re: MySQL ORDER BY or PHP Sort? Oops.

EMAIL PROTECTED] 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

Re: [PHP] Re: MySQL ORDER BY or PHP Sort? Oops.

On Tue, 4 Dec 2001 11:46, René Fournier wrote: > 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 s

[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 that is presenting a challenge: -

Re: [PHP] RE: MySQL ORDER BY or PHP Sort?

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,

[PHP] RE: MySQL ORDER BY or PHP Sort?

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 criteria.