Re: [UMN_MAPSERVER-USERS] connect mysql by using ogr

[Murat BEYHAN]

Dear Greg and friends; Finally I have solved to read data form mysql database than draw map by using those data. I have created Peag Ground Acceleration map for the 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 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 200609151300 earthquake PGA map he/she can change sql statement in ovf file by using php or html commands fromweb... Do you have any idea is it possible or not. Please I wellcome any kind of information about it.. Thank you Murat But I would like to make php file for displaying other On Fri, 15 Sep 2006 08:21:43 +1000, Greg Luker wrote > Hi Murat, > > Have you found a solution to your problem yet? I'm a beginner > mapserver user and I'm using mapserver with MySQL. I am reading > point locations from a MySQL database using OGRVRT  and drawing > those points on a map. Is this what you want to do. I could send my > mapfile to you if that would help. > > Thanks, > Greg. > > Greg Luker > GIS Lab Manager, Southern Cross University > Lismore, AUSTRALIA. > [EMAIL PROTECTED] > phone 61 2 66203026 > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. -- Open WebMail Project (http://openwebmail.org) -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.