: mysql ORDER BY problem
Rob W. wrote:
> It's not in general to mysql, it's how php and mysql is displaying it.
>
That's not what you asked. You asked how to do it with your query,
which has nothing, nadda, zip to do with PHP. You want MySQL to do the
sorting, look at the M
Rob W. wrote:
It's not in general to mysql, it's how php and mysql is displaying it.
That's not what you asked. You asked how to do it with your query,
which has nothing, nadda, zip to do with PHP. You want MySQL to do the
sorting, look at the MySQL manual under the select syntax, or ask o
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, Rob W. wrote:
Is there
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, I'm also
guess
You know, in spite of all the good advice I've received, I think that's
what I'll have to do. I say "have to" because inserting another field
into the table creates some complications (long story... related to the
web admin tool I made for editing the tables). Actually, come to think
of it, th
can you have another field in your table(s) for a "weighting" and then sort
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]
S
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
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,
8 matches
Mail list logo
