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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
