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"
-snip-
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.
Rob:
Yes, there are other titles, such as:
Celtic Deco 1
Lucerne 1
Dutch Hearth 1
and so on...
You can see the sort in action at:
http://ancientstones.com/catalog.php
Thanks.
tedd
--
--------------------------------------------------------------------------------
http://sperling.com