How can Create OVF file (for OGR MYSQL connection) interactively

[Murat BEYHAN]

 Dear friends;
 
 Finally I have solved to read point data form mysql database than draw map by using
 those data.
 I have created Peak Ground Acceleration (PGA) map for the specified earthquake which data are
 stored in MySql. But I would like to display map for all earthquake which are
 described in the Mysql table as eq-id column.I mean PGA data are stored in mysql database.table for several earthquakes
and one of the column is called EQ_ID which use for the seperate PGA data from other earthquake like
EQ_ID            Lon   Lat     PGA
200006060242 30.40 32.45 2.5
200006060242 30.41 32.46 2.6
200006060242 30.42 32.47 2.7
...
200606071708 38.45 40.98 5.6
200606071708 38.46 40.99 5.7
200606071708 38.47 41.00 5.7
200606071708 38.48 41.01 5.8
.
.
.
 I have querid mysql database by using ovf file as following 
 
 <OGRVRTDataSource>
 <OGRVRTLayer name="acceleration">
 
 <SrcDataSource>MYSQL:database,user=user,password=pass_wd,host=100.00.00.21,port=3306,tables=d_pgadata1</SrcDataSource>
 <SrcSQL>SELECT eq_id,latitude,longitude,acceleration from d_pgadata1
 where eq_id like '%200006060242%' </SrcSQL>
 <GeometryType>wkbPoint</GeometryType>
 <GeometryField encoding="PointFromColumns" x="longitude" y="latitude"/>
 </OGRVRTLayer>
 </OGRVRTDataSource>
 
 As you see when I create map by layer OGR this will just the eq_id like
 '%200006060242%'.
 But I would like to change this eq_id by interactively for example who will
 like to see 200606071708 earthquake PGA map he/she can change sql statement in
 ovf file by using php or html commands from web...
 
 Do you have any idea is it possible or not.
 
 Please I wellcome any kind of information about it..
 Thank you 
 Murat

 

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20060919/a10fe6c2/attachment.html