Help with Spatial Extension

[Peter Battaglia]

Hello,

I am having problems getting geometry into my DB table. I am using XAMPP which uses MySQL 5.0. I built my table with a column of type "geometry". I have been able to manually enter a point, but when I try and enter another, different point, it gives me an error regarding "duplicate geometry".

I'm also having issues inserting data through my php scripts. Below is one of the queries I am using:
$insert_statement = "INSERT INTO `order`(geom) VALUES (GeomFromText(POLYGON('$wkt_poly')))";

Where $wkt_poly = (39.75326104990142 -104.97015953063965 , 39.74930171012357 -104.95805740356445 , 39.74633205595244 -104.96458053588867 , 39.74633205595244 -104.96458053588867 , 39.75326104990142 -104.97015953063965)

Thoughts?

Also, anyone know if it's possible to access mysql command line with xampp??
Thanks!



Edited 1 time(s). Last edit at 04/17/2007 08:20PM by Peter Battaglia.