thanks again, i guessed too was the " ; " and I just checked the
tutorial http://code.google.com/apis/maps/articles/phpsqlsearch.html
in those lines and its
mysql_real_escape_string($center_lat),
mysql_real_escape_string($center_lng),
mysql_real_escape_string($center_lat),
mysql_real_escape_string($radius));
$result = mysql_query($query);
$result = mysql_query($query); :::::this is duplicate:::
if (!$result) {
die("Invalid query: " . mysql_error());
}
but here
http://gmaps-samples.googlecode.com/svn/trunk/articles-phpsqlsearch/phpsqlsearch_genxml.php
itss only 1 time that line, now that i corrected that i got other
error message
Invalid query: You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to
use near 'WHERE type = '' ORDER BY distance LIMIT 0 , 20' at line 5
I dont know much php either, and i dotn knw how get a working veriosn
and see the code since the google tutorial seems to be just guides. If
anyone knows please i would appreciate the help.
On Jan 7, 12:51 am, "[email protected]" <[email protected]>
wrote:
> On Jan 6, 9:11 pm, "[email protected]" <[email protected]>
> wrote:
>
> > thanks for your reply, this is at line 40
>
> > $result = mysql_query($query);
>
> > what is the error and how should be?
>
> I don't know (I don't use PHP, and I haven't used MySQL much), but it
> is almost certainly a problem with the PHP and nothing to do with the
> google maps API. I would suggest investigating the value of $query
> and comparing your php to that in the tutorial (or a know working
> version), there is probably a ";" somewhere where there shouldn't be.
>
> -- Larry
>
>
>
> > On Jan 6, 10:25 pm, "[email protected]" <[email protected]>
> > wrote:
>
> > > On Jan 6, 5:06 pm, "[email protected]" <[email protected]>
> > > wrote:
>
> > > > im trying to go step by step reading all tutorials since my goal is is
> > > > to have somethig like this sample with mike and google tutorials i
> > > > did this samplehttp://www.e-bookings.net/maphotelsample.html i did
> > > > my own icons (for now work only Hotels and Places) and i uploded a
> > > > database but i want add a locator function to search hotels , and
> > > > amenites but I dotn want a bunch of markers displayed at once I did
> > > > this other s tutorial having in mind integrate it with my frist sample
> > > > abovehttp://code.google.com/apis/maps/articles/phpsqlsearch.html and
> > > > but it doesnt work (http://www.e-bookings.net/mapsearch.html) and at
> > > > this point im lost since i read all i could about and other post btu
> > > > many links are broken or the site sample are not anymore.
>
> > > > So my question is how to add to this
> > > > pagehttp://www.e-bookings.net/maphotelsample.html
> > > > i already did an address bar to input a city since i want display
> > > > hotels and amenites around the world and show the results in a side
> > > > bar.
>
> > > > Any hints or idea will be very appreciated. Thank you
>
> > > There is a problem with your
> > > phpsqlsearch_genxml.php:http://www.e-bookings.net/phpsqlsearch_genxml.php?lat=47.60621&lng=-1...
>
> > > It says:
> > > Parse error: syntax error, unexpected ';' in /home/ebook/public_html/
> > > phpsqlsearch_genxml.php on line 40
>
> > > -- Larry
--
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.
