Re: [PHPLIB] Please help! From: Joel (comicsboy <email protected>)
Date: 12/30/99

Sorry, it seems that it doesn't work either.

Chris Johnson wrote:

> Try this:
>
> $db->query("select 0 + user_id from members order by user_id desc");
>
> ..chris
>
> > -----Original Message-----
>
> > 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?
>
> -
> 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.

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