Hello, thanks for looking, I really apprecate any help you can give.
What I have done is created a new table in the links database, called Zipcodes, the primary fields are Zip, NearBy The Zip just contains a single zipcode. The NearBy contains at least 5, what I have done is added &zipcode= to the URL.... http://www.XXXXXX.com/cgi-bin/page.cgi?g=&d=1&zipcode=(a zipcode here)
All that works.... In my Links table, I also added a "zipcode" field, whenever I load/display a link etc, I got it to go the the Zipcodes table, pull the info from the "zipcode" in the links table, and find witch city is linked to the that zipcode. All that works fine, it will even display only links has a certain zipcode. HOWEVER what I cant figure out is how to have it go to the Zipcodes table, pull the field "NearBy" and have it search the links witch contain a zipcode with the 5 or so thats in the NearBy field.
Any suggestions?
I have been messing around with build.pm, under sub build_category
What I have done is created a new table in the links database, called Zipcodes, the primary fields are Zip, NearBy The Zip just contains a single zipcode. The NearBy contains at least 5, what I have done is added &zipcode= to the URL.... http://www.XXXXXX.com/cgi-bin/page.cgi?g=&d=1&zipcode=(a zipcode here)
All that works.... In my Links table, I also added a "zipcode" field, whenever I load/display a link etc, I got it to go the the Zipcodes table, pull the info from the "zipcode" in the links table, and find witch city is linked to the that zipcode. All that works fine, it will even display only links has a certain zipcode. HOWEVER what I cant figure out is how to have it go to the Zipcodes table, pull the field "NearBy" and have it search the links witch contain a zipcode with the 5 or so thats in the NearBy field.
Any suggestions?
I have been messing around with build.pm, under sub build_category