Hey Alberto, I've had luck using PHP with a SELECT statement on a MySQL database to write a KML file for use in OpenLayers. As long as your query returns a relatively small subset of features (<500) and your users have a snappy connection with a decent browser, you should be OK using this method. Fortunately you are returning point features with a single set of coordinate pairs, as opposed to complex polygons! A benefit of using KML is that you can also let the user download the results in a fairly common and readily usable GIS format without having to write any additional code. If you are interested I can post my MySQL -> KML PHP script.
Best of luck! BRYAN ----- Bryan R. McBride, GISP http://www.bryanmcbride.com bryanmcbride.com http://geoserving.net/ geoserving.net -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/which-is-the-best-way-to-display-a-set-of-points-coming-from-database-tp5482933p5487113.html Sent from the OpenLayers Users mailing list archive at Nabble.com. _______________________________________________ Users mailing list [email protected] http://openlayers.org/mailman/listinfo/users
