2001 10:05 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Ordering a query
I use the following code to order the results of the query by the
variable $order.
$result = mysql_query("SELECT
articles.title,vote.votes,vote.total,articles.date,staff.firstname,artic
les.content,articles.id FROM sta
I use the following code to order the results of the query by the variable $order.
$result = mysql_query("SELECT
articles.title,vote.votes,vote.total,articles.date,staff.firstname,articles.content,articles.id
FROM staff,articles,vote WHERE articles.authorid = staff.id AND articles.id =
vote.it
uot;George Pitcher" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, September 07, 2001 9:00 AM
Subject: Re: [PHP] ordering a query
> It is simply ordering them as type data rather than as type integer.
Change
> your data type in the db
It is simply ordering them as type data rather than as type integer. Change
your data type in the db.
George, a newbie
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 07, 2001 9:16 AM
Subject: [PHP] ordering a query
Me again
Me again :)
I have a query that orders by id#, the problem is I have 17 items and I get an output
like so: 1,10,11,12,13,14,15,16,17,2,3,4,5,6,7,8,9
So it thinks 1 and 10 are the same, and it thinks 11 is less than 2 and so on and so
forth. Remedy please? (I'd rather not rename the items 01, 0
5 matches
Mail list logo