We have a CRM which is written in PHP. We are having some problems with the database.
There are two issues which need to be addressed.
1) The list of suburbs is not coming properly. It has to be in Alphabetical order. What is happening is it lists suburbs in alphabetical order but goes A-Z and then A-z again. For some reason it is splitting the list in 2 pcs and arranging it in alphabetical order. This needs to be fixed. See attached pdf for more info.
2) Some of the suburbs are missing. They are in the database but not getting listed. I have a doubt that some of the suburbs has same ID and that's why not showing up.
This is a urgent project and needs to be fixed ASAP.