Hi, Thanks for your suggestion. But when printing the results from the database it prints in the same order as it fetches. Also, I have two sets of diseases. Say: disease_1:

1 flu
1 cold
2 measles
[download]

and another set of disease like:

1 diabetes
2 typhoid
[download]

Those two sets are distinguished based on the process they go for. there may be some disease which appears in both the sets.
The diseases are not the exact names but an example of it. The Query fetches different process that the disease has passed through. But I think that doesn't matter us much(!) here. The problem is I am having the same problem again that is ,the order of the disease is not in the order that I have got in the array but IT comes randomly as it fetches in the database. for example:

XXX:measles  45  35  67  1000
XXX:flu      67  35  45  7000
XXX:typhoid  56  78  89  1000
[download]

Note the XXX:disease is the way the disease is stored inthe database.
What I need to have is the exact order and priority number along with the exact names that I have stored in the array.
Thanks for your suggestions.