calculate distance between two coordinates?

Discussion in 'Databases' started by Lordy, Mar 5, 2008.

0
  1. #1
    edit solved
     
    Lordy, Mar 5, 2008 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    The logic seems correct. Are you getting any output from it at all?

    Maybe try: SELECT SQRT(POW((50-x),2)+POW((60-y),2))
     
    jestep, Mar 5, 2008 IP
  3. 00johnny

    00johnny Peon

    Messages:
    149
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    What was your solution? I know a guy who wants to do this, any help you could give would be great...
     
    00johnny, Mar 5, 2008 IP