Help with query

[mikawhat]

I have the following query:

SELECT LAN_details.image1, LAN_details.name, LAN_details.telephone 
FROM LAN_details, LAN_detailcategory, LAN_category 
WHERE LAN_details.id=LAN_detailcategory.detailid 
AND LAN_category.id=LAN_detailcategory.categoryid 
AND LAN_category.name='bars' 
ORDER BY LAN_details.id LIMIT 5, $num

Is there a way to display this result in alphabetical order?

[laserlight]

Yes, by using ORDER BY as you have done, but with something that is alphabetical.

[mikawhat]

i have to use ORDER BY LAN_details.id in order to exclude the first 5 entries from my query. Then i want the result of my query to be displayed alphabetically...

[laserlight]

Oh, I see. One way is to do the ordering in PHP with [man]sort/man or even [man]natsort/man after placing the result rows into an array. I am not too sure how to do it all in one query, though a subquery is one option, in my opinion. It might be something like this:

SELECT * FROM
    (SELECT LAN_details.image1, LAN_details.name, LAN_details.telephone 
        FROM LAN_details, LAN_detailcategory, LAN_category 
        WHERE LAN_details.id=LAN_detailcategory.detailid 
            AND LAN_category.id=LAN_detailcategory.categoryid 
            AND LAN_category.name='bars' 
        ORDER BY LAN_details.id LIMIT 5, $num)
    ORDER BY LAN_details.name