Hi Sir,
Thanks for your reply, i understood 2nd and 3rd problems and
changed according to your suggestion. But i am not understanding about the
1st problem. I have route_name column in my table. Below i am givng
description of my table...
+-------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+----------------+
| route_id | int(11) | NO | PRI | NULL | auto_increment |
| start_point | varchar(80) | NO | | NULL | |
| end_point | varchar(80) | NO | | NULL | |
| geo_points | text | NO | | NULL | |
| route_name | varchar(80) | NO | | NULL | |
| distance | int(11) | NO | | NULL | |
+-------------+-------------+------+-----+---------+----------------+
sorry for above lines....
when i was trying to edit with firebug it is showing that invalid query??
$query="SELECT * FROM route where route_name=" .$_GET['route_name'];
but i am not understanding what is the problem in this query, please help me
regarding this.
Thanks in advance,
with sincerely,
sravan
On Mon, Mar 23, 2009 at 12:15 PM, Mike Williams
<[email protected]>wrote:
>
> I can see three obvious problems:
>
> 1. There is no column called "route_name" in the "route" table of your
> database, so this will always fail
> "SELECT * FROM route where route_name=" .$_GET['route_name']
>
> 2. There's an "=" missing on this line
> var url= "routekml_poly.php?route_name"+route_name;
> The parameter string should look like ?route_name=foo, not
> ?route_namefoo
>
> 3. You ignore the data obtained by GDownloadUrl(url), and instead use
> GGeoXml('http://googlemaps.uuuq.com/route/routekml_poly.php'<http://googlemaps.uuuq.com/route/routekml_poly.php%27>),
> passing
> no parameter to your server. Your server isn't designed to cope with the
> situation where there's no parameter, and produces invalid MySQL query
> syntax.
>
> --
> http://econym.org.uk/gmap
> The Blackpool Community Church Javascript Team
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
