Am stuck with this error message.. :(
Warning: pg_query() [function.pg-query]: Query failed: ERROR: LIMIT
#,# syntax is not supported HINT: Use separate LIMIT and OFFSET
clauses.in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs
\map2.php on line 30
*************
$query = sprintf("SELECT place_id, place_name, lat, lng, ( 6371 * acos
( cos( radians('%s') ) *
cos( radians( lat ) ) * cos( radians( lng ) - radians('%s') ) + sin
( radians('%s') ) * sin(
radians( lat ) ) ) ) AS distance FROM places HAVING distance < '%s'
ORDER BY distance LIMIT 0 ,
20",
pg_escape_string($center_lat),
pg_escape_string($center_lng),
pg_escape_string($center_lat),
pg_escape_string($radius));
*************
Line 30 is: $result = pg_query($link,$query);
How do I alter syntax of select statement?!
Thanks.
On Nov 18, 6:06 pm, Ricky <[EMAIL PROTECTED]> wrote:
> Isn't this is how my URL should look?!
>
> http://localhost:8080/map2.php?lat=17&long=80&radius=25
>
> On Nov 18, 5:49 pm, Ricky <[EMAIL PROTECTED]> wrote:
>
> > Hey Thanks for that link.. Am working on it, trying to get it to work
> > with PostGreSQL..
> > _real_escape_string part is showing an error? replaced mysql with
> > pg.. guess there is more to it.
> > Will try to figure out whats wrong..
>
> > Ricky
>
> > On Nov 17, 1:58 pm, mapperzUK <[EMAIL PROTECTED]> wrote:
>
> > > You need to use a location and do a spatial search on your 1200
> > > markers but restricting the search by a distance
>
> > > seehttp://code.google.com/support/bin/answer.py?answer=87134&topic=11364...
>
> > > quote:
> > > "Here's the SQL statement that will find the closest 20 locations that
> > > are within a radius of 25 miles to the 37, -122 coordinate. It
> > > calculates the distance based on the latitude/longitude of that row
> > > and the target latitude/longitude, and then asks for only rows where
> > > the distance value is less than 25, orders the whole query by
> > > distance, and limits it to 20 results. To search by kilometers instead
> > > of miles, replace 3959 with 6371. "
>
> > > This will make your map faster.
>
> > > Mapperzhttp://mapperz.blogspot.com/
>
> > > On Nov 17, 3:46 am, Ricky <[EMAIL PROTECTED]> wrote:
>
> > > > Was going through this
> > > > link:http://code.google.com/apis/maps/documentation/overlays.html
>
> > > > But how can I alter this code to incorporate the markers at different
> > > > zoom levels?
> > > > Do i have a new field which can have integer values. Assigning the
> > > > same integer value to all which needs to be shown at a particular zoom
> > > > level. Will that be the way to go about?!! Then use an If-else to
> > > > load based on the integer value?
>
> > > > **********************************
>
> > > > function createMarker(point,html,icon) {
> > > > var marker = new GMarker(point,icon);
> > > > GEvent.addListener(marker, "click", function() {
> > > > marker.openInfoWindowHtml(html);});
>
> > > > return marker;
>
> > > > };
>
> > > > <?php
>
> > > > $link = pg_connect("host=localhost port=5432 dbname=place user=abc
> > > > password=xyz") or die("Could not connect: " . pg_error());
>
> > > > $result = pg_query($link,"SELECT * FROM places");
> > > > if (!$result)
> > > > {
> > > > echo "no results ";
>
> > > > }
>
> > > > while($row = pg_fetch_array($result))
> > > > {
> > > > echo "var point = new GLatLng(" . $row['lat'] . "," . $row['long'] .
> > > > ");\n";
> > > > echo "var marker = createMarker(point, '" . addslashes($row
> > > > ['place_name']) . "',pin);\n";
> > > > echo "map.addOverlay(marker);\n";
> > > > echo "\n";
>
> > > > }
>
> > > > *************************
> > > > What changes to be made here?! Also right now all the 1200+ markers
> > > > are loading at the same time. So its taking time to load them. Will
> > > > need to scale this to 32000+ markers. So it has to be zoom levels
> > > > which I should be working on I guess.
>
> > > > Thanks in advance
> > > > Ricky
>
> > > > On Nov 13, 8:46 pm, Ricky <[EMAIL PROTECTED]> wrote:
>
> > > > > Thanks everyone.. Looked at the error log and finally understood it
> > > > > was cos the php_pgsql.dll was not present.. Downloaded it.. Made
> > > > > changes on the php.ini file and yipee..!! It now works..
>
> > > > > Also deleted this line--- pg_selectdb("places",$link) or die ("Can\'t
> > > > > use dbmapserver : " .pg_error());
>
> > > > > Can go sleep in peace.. :)
>
> > > > > On Nov 13, 5:59 pm, tunerGeek <[EMAIL PROTECTED]> wrote:
>
> > > > > > You won't ever see PHP code (<?php) in your view source, only the
> > > > > > HTML
> > > > > > that PHP generates. That's one reason for require'ing / include'ing
> > > > > > your db connection info... if PHP fails on your server, it cannot
> > > > > > expand the connect info and thus not ever release that info to the
> > > > > > public.
>
> > > > > > For PHP errors, take a peek at your apache error log.
>
> > > > > > On Nov 13, 5:07 am, Ricky <[EMAIL PROTECTED]> wrote:
> > > > > > <snip>
>
> > > > > > > So the code starting from "<?php " is not to be seen.
>
> > > > > > > Some error there..!!
>
> > > > > > > On Nov 13, 3:58 pm, Rossko <[EMAIL PROTECTED]> wrote:
>
> > > > > > > > You might get a clue by doing a simple 'view source' on your
> > > > > > > > blank
> > > > > > > > page - what's really in there?
>
> > > > > > > > cheers, Ross K
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Google Maps API" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/Google-Maps-API?hl=en
-~----------~----~----~----~------~----~------~--~---
