SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. Jan 5, 2009, 00:59 #1
    matsko
    matsko is offline
    $books++ == true matsko's Avatar
    Join Date
    Sep 2004
    Location
    Toronto
    Posts
    795
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL Geo/Spacial Search

    I have to design a website where users will be interacting with a map in depth. One feature is a "nearby" lat/lon searching capability.

    I'm planning to use the MySQL spacial indexing features, but I have no idea how they function.

    Can anyone fill me in?

    Thanks
    I can't believe I ate the whole thing
  2. Jan 5, 2009, 02:19 #2
    poizn
    poizn is offline
    SitePoint Addict
    Join Date
    Jun 2006
    Location
    Durban, South Africa
    Posts
    287
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The MySQL site explains things very well.
    Here is the page about index's

    http://dev.mysql.com/doc/refman/5.0/...l-indexes.html
  3. Jan 5, 2009, 02:36 #3
    r937
    r937 is offline
    SQL Consultant gold trophysilver trophybronze trophy
     r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,347
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    poizn, that page is just about indexes

    i think this is what he's after --
    http://dev.mysql.com/doc/refman/5.1/...xtensions.html
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"
  4. Jan 5, 2009, 02:49 #4
    poizn
    poizn is offline
    SitePoint Addict
    Join Date
    Jun 2006
    Location
    Durban, South Africa
    Posts
    287
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hey cool post r937.
    Learn something new everyday

« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules