Re: [PHP-DB] changing datatypes in the query

2003-08-27 Thread CPT John W. Holmes
From: "Matt Babineau" <[EMAIL PROTECTED]> > On Tue, 2003-08-26 at 11:21, Matt Babineau wrote: > > Tough question (I think). I am pulling some numbers out of a data base, > > currently they are stored in a blob. When I try to "order by user_hits > > desc" it does a text ordering, not a numerical ord

Re: [PHP-DB] changing datatypes in the query

2003-08-26 Thread Matt Babineau
I think I answered my own question, I used CAST() to set the type in the ORDER BY statement. cast(s11.data as unsigned) Thx to me! Matt On Tue, 2003-08-26 at 11:21, Matt Babineau wrote: > Hi all- > > Tough question (I think). I am pulling some numbers out of a data base, > currently they are st