[OpenLayers-Users] Mapping areas from database

[jtrsmith at gmail.com]

I am new to openlayers, so please excuse my lack of knowledge here.

I have set up a map of my college campus in openlayers and would like  
to add some functionality to it.

What I am looking to do is have locations ( prefferably rectangular
polygon areas ) set up that when clicked will open a popup and show a  
photograph of the location. I have a database set up in SQL with the  
names, locations, and photographs. I am just not sure how to get the  
information to show on my map.

I did look at the examples, some of them help, but I am still unsure
how I can use the database information on my map. I have added a popup  
to my map using the example in select-feature-openpopup, however I am  
unable to add multiple locations with different information. Should I  
be using an XML document to populate my map? How would I set up  
openlayers to get that information?

Sorry for the long post, can anyone point me in the right direction?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/openlayers-users/attachments/20091223/e344f1b5/attachment.html