Re: Natural order of things.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



You could try separating out the number an formatting it with SQL and doing an ORDER BY on the post-processed number.  It doesn't have to appear in the SELECT <columns> portion to be able to use it in the ORDER BY section.


SELECT BookName, PageNum, Citation FROM BookQuotes ORDER BY LPAD(PageNum,4,'0');

You could also probably convert the number from a string to an actual number so it sorted numerically.

I think you get the idea.  Give it a try and let us know!  Then go back to the MySQL list and tell them how great PHP is.

-TG

= = = Original message = = =

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

tedd
-- 
--------------------------------------------------------------------------------
http://sperling.com



___________________________________________________________
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.

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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux