[PHP-DB] mysql ORDER BY problems

2006-06-18 Thread Rob W. 
Ok, here's what i got in my mysql db. I got a table listed with numbers as 
follows

1
2
3
4
5
6
7
10
11
12
13
14
15
16
17
18
19
20
21
22
25

These numbers I can display fine. I'm using ..

$query=SELECT * FROM db ORDER BY numbers ASC;

Right now it displays it as

1
10
11
12
.
2
22
23
25

3
4
5
6
7

Is there a way with my mysql query so that I can list the numbers in correct 
order?

Any help is appricated.

- Rob

[PHP-DB] re: mysql ORDER BY problems

2006-06-18 Thread J. Alejandro Ceballos Z. -JOAL- 

are they defined as integer or varchars (string)?

try
 a) exchange field definition varchar / integer
 b) order by length(number) and later by number

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] mysql ORDER BY problems

2006-06-18 Thread Bastien Koert 


if you have these as strings, I would recommend a column data type 
conversion to int(or other numeric as the case may be)failing that I 
would use the CAST command to convert the data to numerics


see here

http://dev.mysql.com/doc/refman/4.1/en/cast-functions.html

to use

select cast(fieldname as integer) from table where ... order by ...

bastien


From: Rob W. [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] mysql ORDER BY problems
Date: Sun, 18 Jun 2006 17:19:03 -0500

Ok, here's what i got in my mysql db. I got a table listed with numbers as 
follows


1
2
3
4
5
6
7
10
11
12
13
14
15
16
17
18
19
20
21
22
25

These numbers I can display fine. I'm using ..

$query=SELECT * FROM db ORDER BY numbers ASC;

Right now it displays it as

1
10
11
12
.
2
22
23
25

3
4
5
6
7

Is there a way with my mysql query so that I can list the numbers in 
correct order?


Any help is appricated.

- Rob




--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php