sorry the late reply,
could you consider having each set of coordinates in 2 different fields?
select r.x, r.y from room r
andr�s
----- Original Message -----
From: "Roger Southwick" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 16, 2002 12:18 AM
Subject: [PHP-DB] Semi-newbie - postgres polygon/points and PHP?
> Ok, a kinda newbie question. I set up a Postgres DB with a table that had
a
> Point and a Polygon in it (to hold XY and shape settings for munging a
jpeg
> image in php).
>
> I could not easily figure out how to extract the data into a reasonably
easy
> to use format in PHP. The best I could do seemed like it was extracted
> into a string, and then I had to parse that.
> While this works, it seems like a BIG hack to me, and the docs have been
> less then forthcoming.
> I've also tried the usual google search of "php postgres polygon" to see
if
> I could get an idea.
>
> For example, I stored the Point as: (432, 120)
> And I got "(432, 120)" as a string, and had to parse it:
>
> ...
> $Q = "SELECT * FROM room WHERE id=$id";
>
> if(!($Result = pg_exec($Connection, $Q)))
> {
> print("Query failed $Q");
> print(pg_errormessage($Connection));
> print("<BR>\n");
> exit;
> }
>
> $myroom = pg_fetch_array($Result, $i);
> $xy = $myroom["xy"];
> $xyar = split("[\(,\)]", $xy);
> $x = $xyar[1];
> $y = $xyar[2];
> ...
>
>
> Any ideas?
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
