what is your criteria to make a city favourite???
I propose to give a Ranking to every city and store it in a field(say city_ranking) in your table
Now u can easily have your favourite city with a sql like
SELECT city_name FROM tblCity WHERE city_ranking>50
User will mark a few cities as favourites- which he might need frequently.
I want to show favourite city (ranking >10) on top of the list but the complete list should also appear below those cities.
I need the text & also Value- CityId of each ListItem. As I'll insert the CityId of the selected city in my Prospects Table. I want favourite cities on top as the user should not waste time in searching the list. The ranking can be changed when ever user wishes.
eg. Dropdown list should look like this:(Delhi has rank 1, Banglore 2 & Hyderabad 3). If I have to enter US,UK prospects, I'll mark NY, London as my favourites.
Delhi
Banglore
Hyderabad
----------
Alicante
Banglore
Barcelona
Basel
Buchrain Luzern
Dällikon
Delhi
Igualada
Hyderabad
Madrid
Shanghai