I'm programming in MySQL and PHP.
This seemed like quite a simple problem to me at first, but suddenly it seems a few steps beyond my current abilities.
I'm wanting to have a search statement which pulls out records in order of the 'region' field in my database. Now that's easy enough. But the way I want to order is is having for example 'Bristol' first.
(also it won't always be bristol, so it doesn't help that it's near the start of the alphabet. The region which I want to appear first is a variable).
Any help would be greatly appreciated