Welcome Guest, Not a member yet? Register   Sign In
Question on infowindow_content of Google Map API V3
#4

[eluser]Desmond[/eluser]
Hi Steve, I have one more question but it's not codeIgniter, it's about SQL.
I am a newbie. Sorry for keep asking questions.
I have searched the solution for two days. I will be very grateful if you can help me.

In my phpmyadmin SQL database, I have hundreds of Google map URL. I want to change them into lag and lng automatically.

For example:
http://maps.google.com.hk/maps?f=q&sourc...19&iwloc=A

How can I write a SQL instruction to extract lag and lng out of it?
Seems all lag and lng are after & ll=
In the example: &ll=22.279429,114.181622

Thanks so much if anyone could help ;-)


Messages In This Thread
Question on infowindow_content of Google Map API V3 - by El Forum - 02-02-2012, 11:29 AM
Question on infowindow_content of Google Map API V3 - by El Forum - 02-02-2012, 03:58 PM
Question on infowindow_content of Google Map API V3 - by El Forum - 02-03-2012, 12:40 AM
Question on infowindow_content of Google Map API V3 - by El Forum - 02-03-2012, 10:08 AM



Theme © iAndrew 2016 - Forum software by © MyBB