Re: Natural order of things.

On Wed, 2006-04-26 at 16:57, Robert Cummings wrote: > On Wed, 2006-04-26 at 16:51, tedd wrote: > > Hi gang: > > > > I posted the following question to the MySQL list, but the only > > answer I received thus far was a php solution (it didn't work for > > what I wanted). > > > > As such, maybe if I post a MySQL question to the PHP group, then I'll > > receive a MySQL answer -- so here goes: > > > > I'm using the following query, and it works. > > > > SELECT id, title, url_image_small > > FROM $dbtable > > WHERE type="type_title" > > ORDER BY title > > LIMIT $offset, $rowsPerPage" > > > > But, it sorts stuff like this: > > > > Basel Square 1 > > Basel Square 10 > > Basel Square 11 > > Basel Square 2 > > Basel Square 3 > > Basel Square 4 > > Basel Square 5 > > Basel Square 6 > > Basel Square 7 > > Basel Square 8 > > Basel Square 9 > > > > What do I have to change to get it (the query) to sort like this: > > > > Basel Square 1 > > Basel Square 2 > > Basel Square 3 > > Basel Square 4 > > Basel Square 5 > > Basel Square 6 > > Basel Square 7 > > Basel Square 8 > > Basel Square 9 > > Basel Square 10 > > Basel Square 11 > > > > Thanks in advance for any answers/suggestions > > You need ot perform a type conversion from string to integer. Sorry, just realized... "Basel Square" is part of the entry in the table :/ Do you have entries that aren't prefixed with Basel Square? Cheers, Rob. -- .------------------------------------------------------------. | InterJinn Application Framework - http://www.interjinn.com | :------------------------------------------------------------: | An application and templating framework for PHP. Boasting | | a powerful, scalable system for accessing system services | | such as forms, properties, sessions, and caches. InterJinn | | also provides an extremely flexible architecture for | | creating re-usable components quickly and easily. | `------------------------------------------------------------'