<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">I don't have a simple example, no. But this is a geoserver/openlayers question, so I suggest you start here<div><br></div><div><a href="http://docs.geoserver.org/">http://docs.geoserver.org/</a></div><div><br></div><div>Install it and give it a try, and ask on the geoserver list if you have any questions. Sql views are documented here:</div><div><br></div><div><a href="http://docs.geoserver.org/stable/en/user/data/sqlview.html">http://docs.geoserver.org/stable/en/user/data/sqlview.html</a></div><div><br></div><div>But if you want to use php, I'd look into other WMS servers. Perhaps mapserver would suit you better, but I am not familiar with it enough to know.</div><div><br></div><div>Also, check the archives for this list for the last few days, but someone asked a similar question and Stephen linked to this demo of his that might be useful to you</div><div><br></div><div><a href="http://gis.imaptools.com/routing/leaddog">http://gis.imaptools.com/routing/leaddog</a></div><div><br></div><div>hth</div><div>charles</div><div><br><div><div>On Aug 17, 2011, at 4:49 AM, javad sadidi wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">hi thanks for your answer.<br>can you show an example in more details?<br><br><br><div class="gmail_quote">On Wed, Aug 10, 2011 at 11:17 PM, Charles Galpin<span class="Apple-converted-space"> </span><span dir="ltr"><<a href="mailto:cgalpin@lhsw.com">cgalpin@lhsw.com</a>></span><span class="Apple-converted-space"> </span>wrote:<br><br class="Apple-interchange-newline"></div></blockquote></div><br></div></body></html>