Jump to content


Photo

Setting Limit


  • Please log in to reply
24 replies to this topic

#21 Barand

Barand
  • Moderators
  • Sen . ( ile || sei )
  • 18,021 posts

Posted 24 September 2006 - 10:47 PM

No. I'm flying blind as I don't have any data to test on.
If you are still using mysql_ functions, STOP! Use mysqli_ or PDO. The longer you leave it the more you will have to rewrite.

Donations gratefully received






moon.png

|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts

#22 Barand

Barand
  • Moderators
  • Sen . ( ile || sei )
  • 18,021 posts

Posted 24 September 2006 - 10:49 PM

Are there any members in AB10?
If you are still using mysql_ functions, STOP! Use mysqli_ or PDO. The longer you leave it the more you will have to rewrite.

Donations gratefully received






moon.png

|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts

#23 CanMan2004

CanMan2004
  • Members
  • PipPipPip
  • Advanced Member
  • 254 posts

Posted 24 September 2006 - 10:52 PM

a sample of my postcodes table is

postcode  district  x  y  latitude  longitude
MK46 Milton Keynes 489500 251500 52.15 -0.69
MK5 Milton Keynes 483500 236500 52.02 -0.78
MK6 Milton Keynes 486300 237600 52.03 -0.74
MK7 Milton Keynes 489900 236500 52.01 -0.69
MK8 Milton Keynes 482100 238200 52.03 -0.8

and a sample of my members table is

id,name,postcode
34,fg hills,MK6 5TT
35,b w,MK6344
36,t h,MK8 2EE

so ive been working out the closest postcodes using the x and y fields in postcode and then returning the members details by matching the first part of the closest matching postcodes

does this help?

#24 CanMan2004

CanMan2004
  • Members
  • PipPipPip
  • Advanced Member
  • 254 posts

Posted 24 September 2006 - 10:53 PM

Yes, there are about 26 matching AB10

#25 Barand

Barand
  • Moderators
  • Sen . ( ile || sei )
  • 18,021 posts

Posted 24 September 2006 - 10:59 PM

Looking at your data the idea of joining the tables on postcode is a non-runner - codes in postcode table do not match those in members. The only way it would work is the postcode halves were held in 2 columns in the members table
If you are still using mysql_ functions, STOP! Use mysqli_ or PDO. The longer you leave it the more you will have to rewrite.

Donations gratefully received






moon.png

|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users