[Users] How to perform spatial search

[Jehanzeb Orakzai]

Hi, 
I am using GeoExt, ExtJS, and OpenLayers to develop the front end for web mapping, GeoServer to serve maps as WMS and WFS & PostgreSql/PostGIS for database having spatial and non-spatial data. 
I have cities & school data as point in their respective tables in the database which are publish through GeoServer. School table is linked with cities using cityID. 
I want to develop a form that contains cities as text box and school as dropdown loaded from the database, so that a user can perform search on it and the map is zoomed to that particular area with non-spatial information display in a separate grid. 
I don’t know how to load the data in the combo box / dropdown from the DB using the above software stack and perform some searching. How to zoom to a particular location based on the criteria and display non-spatial data in grid. 
I need some guidelines or examples for the problem stated above. 
Can somebody help me in achieving this? 
Any help is appreciated.


 
Thank you,
--
Jehanzeb


      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.geoext.org/pipermail/users/attachments/20100720/21b86e6c/attachment-0001.htm