New Search Engine problem

Posted on 16th Feb 2014 07:03 pm by admin

Hey everyone,

I have a ZIP Code Radius search engine already functional. it displays all of the ZIP codes within a specified mileage around a central ZIP code.

I have an auction site that the client wants the search engine to be able to search for items within a given mileage radius.

I.e. if a person wants to search for corn within 20 miles of the 12345 ZIP code, they want those auctions displayed.

What is the best way to do this?

Like I said I already have the ZIP Code radius search engine working... now I need to be able to searhc for a particular item within those ZIP Codes.

Everything is running from the same MySQL Database.

You can see the site at http://www.harvestauction.com

Under the 'Buy' Menu item you see the 'Search by ZIP' page which directs you to the ZIP Code Radius search.

The database is named 'harvestauction', the table in the DB which are used by the Zip Code Radius is 'zip_codes' and the fields are:

zipcode
latitude
longitude
city
state
country
type

The table with the auctions is: 'jos_bid_auctions'. And those fields are:

id
userid
title
shortdescription
description
picture
link_extern
initial_price
currency
BIN_price
auction_type
automatic
payment
shipment_info
shipment_price
start_date
end_date
closed_date
params
published
closed_offer
closed_by_admin
hits
modified
newmessages
winnerid
cat (category)
auction_nr
nr_items
featured
reserve_price
min_increase
extended_offer
payment_info

Would it be better to first search via ZIP code and then the item in question... or the item first and than the zip codes within the specific area?



I figured that either way... I need the following fields searched in the jos_bid_auctions:

shortdescription
description
cat

And the following fields searched in zipcode:

zipcode

Thank you

Your Answer:

Login to answer

Other forums

problem with sql querry in php script
Hello guys,

What I want to do is I want to read out a csv file and then but te conent ot the

What are causes of a connection-timeout with fopen()?
Hello! Here is the situation: The server I host my website on just upgraded it's PHP build from 4.4.

[function.file]: failed to open stream: No such file or directory
Okay I wrote this little script to upload a csv file that is located on my webhosts server to a mysq

FPDF Help
I've been playing with the FPDF module. I was building a form and rolling right along and then sudde

Sales orders ans reservations not taken into account on MPS / MRP
Hello,

I am implementing the MPS / MRP and I have the following problem:

I ha

PHP Captcha Error help - replace the "die" command
Hi All,

I am after a bit of help with a Captcha spam protection box.

The site gave me

! = ''
In the following 'IF' statement if v_ompcat = PU for example then Oracle equates that 'IF' statement

help understanding hidden input w/ php
hello i'm doing a tutorial where there are multiple forms for an edit page for a user to update thei

Generate PDF
Hi guys,

I would like to know if there is a way to generate pdf when clicking on a link. In f

Using two $_POST Function / Switch () statements, second does not work.
Hi all. I’m new to php and am having a problem getting $_POST Function / switch () to work. I