<HTML>
<HEAD>
<META content="text/html; charset=iso-8859-9" http-equiv=Content-Type>
<META content="OPENWEBMAIL" name=GENERATOR>
</HEAD>
<BODY bgColor=#ffffff>
<font size="2"><b>Dear Greg and friends;
<br />
<br />Finally I have solved to read data form mysql database than draw map by using
<br />those data.
<br />I have created Peag Ground Acceleration map for the earthquake which data are
<br />stored in MySql. But I would like to display map for all earthquake which are
<br />described in the Mysql table as eq-id column.
<br />I have querid mysql database by using ovf file as following
<br />
<br /><OGRVRTDataSource>
<br /> <OGRVRTLayer name="acceleration">
<br />
<br /><SrcDataSource>MYSQL:database,user=user,password=pass_wd,host=100.00.00.21,port=3306,tables=d_pgadata1</SrcDataSource>
<br /> <SrcSQL>SELECT eq_id,latitude,longitude,acceleration from d_pgadata1
<br />where eq_id like '%200006060242%' </SrcSQL>
<br /> <GeometryType>wkbPoint</GeometryType>
<br /> <GeometryField encoding="PointFromColumns" x="longitude" y="latitude"/>
<br /> </OGRVRTLayer>
<br /></OGRVRTDataSource>
<br />
<br />As you see when I create map by layer OGR this will just the eq_id like
<br />'%200006060242%'.
<br />But I would like to change this eq_id by interactively for example who will
<br />like to see 200609151300 earthquake PGA map he/she can change sql statement in
<br />ovf file by using php or html commands fromweb...
<br />
<br />Do you have any idea is it possible or not.
<br />
<br />Please I wellcome any kind of information about it..
<br />Thank you
<br />Murat
<br />But I would like to make php file for displaying other
<br />
<br />
<br />
<br />On Fri, 15 Sep 2006 08:21:43 +1000, Greg Luker wrote
<br />> Hi Murat,
<br />>
<br />> Have you found a solution to your problem yet? I'm a beginner
<br />> mapserver user and I'm using mapserver with MySQL. I am reading
<br />> point locations from a MySQL database using OGRVRT and drawing
<br />> those points on a map. Is this what you want to do. I could send my
<br />> mapfile to you if that would help.
<br />>
<br />> Thanks,
<br />> Greg.
<br />>
<br />> Greg Luker
<br />> GIS Lab Manager, Southern Cross University
<br />> Lismore, AUSTRALIA.
<br />> gluker@scu.edu.au
<br />> phone 61 2 66203026
<br />>
<br />> --
<br />> This message has been scanned for viruses and
<br />> dangerous content by MailScanner, and is
<br />> believed to be clean.
<br />
<br />
<br />--
<br />Open WebMail Project (http://openwebmail.org)
<br /></b>
<br />
</font>
</BODY>
<br />--
<br />This message has been scanned for viruses and
<br />dangerous content by
<a href="http://www.mailscanner.info/"><b>MailScanner</b></a>, and is
<br />believed to be clean.
</HTML>