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