Hi list, A nut to crack: I have a medium-sized database(about 1000 rows). The keys contain zip-address-information. Now I want to get the surrounding persons, e.g. someone has zip 12345 I would get(now for 4 entries): +-------+----------+ | 12340 | personA | | 12345 | personB | <-- I searched for this | 12345 | personC | | 12347 | personD | +-------+----------+ As you see, it's no simple arithmetical question. At the moment I fill an temptable w/ ids and select then - is there another way?
regards, jan it would be nice if my sql could execute a query. thank you ezlm. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php