How do i extend my PHP sql query to generate Polylines?

Hello,

I use the attached script to query my database to generate XML for a series of markers for my site. I want to extend this so that it also generates Polylines as demonstrated in this example:
http://econym.googlepages.com/basic7.htm

The complete contents of my database can be seen using the attached script:
www.globexposure.net/includes/read.php

I want to create LINES between my markers in order of record 'id', where they have the same value against 'route' in my database. How do i need to extend the attached PHP script to do this?


Your help is greatly appreciatedStart Free Trial