Date: 12/29/99
- Next message: Chris Johnson: "RE: [PHPLIB] Please help!"
- Previous message: Olaf Jaeger: "[PHPLIB] session problems with mssql"
- Next in thread: Chris Johnson: "RE: [PHPLIB] Please help!"
- Reply: Chris Johnson: "RE: [PHPLIB] Please help!"
- Reply: Stanislav Malyshev: "Re: [PHPLIB] Please help!"
- Reply: Claes Månsson: "Re: [PHPLIB] Please help!"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Dear all,
How to convert a string to numbers in mysql sql statement?
eg. $db->query("select user_id from members order by user_id desc");
however, the user_id type is string type.
For the table, the user id is of string type but with value
1,2,3,4,5....1000. However, if I use the sql statement above, the
results becomes
5
4
3
2
1
1000
But I want to display 1000 first.
How can I achieve it?
Best regard,
Joel
-
PHP3 Base Library Mailing List. Send messages to <phplib <email protected>>.
To unsubscribe, send "unsubscribe" to <phplib-request <email protected>> in
the body, not the subject, of your message.
- Next message: Chris Johnson: "RE: [PHPLIB] Please help!"
- Previous message: Olaf Jaeger: "[PHPLIB] session problems with mssql"
- Next in thread: Chris Johnson: "RE: [PHPLIB] Please help!"
- Reply: Chris Johnson: "RE: [PHPLIB] Please help!"
- Reply: Stanislav Malyshev: "Re: [PHPLIB] Please help!"
- Reply: Claes Månsson: "Re: [PHPLIB] Please help!"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

