Hi thanks to Captain Paralytic I have made a great start to my project
of converting an access system to php and mysql. I now have a query
that functions works and displays the correct results.

This query runs within a PHP results page and displays the results on
screen fine. However as soon as I add an order by statement to the end
of the query, I get a default windows page saying the page cant load.
If I comment the order out the page loads fine again?

The query runs fine in the query browser with the order statement in
place, really confused by this one.

Thanks, Learning fast.
Glyn