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
extract content from a website
i have written a code that will grab the content from the index page..i would like to know how can i leech completely thru the site (index,contact, news pages) and grab specific content only like
download directory onto C drive
I am attempting (if this is possible) to write a routine to automatically dump the contents of a directory on the server into a directory on the local C drive.I started out like this :Code:
LinkedList help
Ok so I just learned quickly about lists, so I have a not too hard project I think, but am having a few issues:Here is the project. Create a lovely polynomial calculator, that takes the equation from
Calling variables
I want to call this to my website but it doesn't display what I want it to,Code: <h5>Edit Subject: <?php echo $sel_subject['menu_name']; ?></h5>If I change
Fetching META TAGS through
Hello everybodyI want to fetch meta tags of a domain.It will be done from following code of index.phpCode: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
how to get IP address?
hey guys,i have this code which is supposed to get me the IP address of my site visitors:Code: <?php if ($_SERVER['HTTP_X_FORWARD_FOR']) {$ip = $_SERVER['HTTP_X_FORWARD_FOR'];} else {$ip =
Logic question
im wondering what's the best method to do the above list:it is for alliance @ MMORPG game -the administrator of alliance have 10 slots for creating ranks ... each rank have it's own permissions (in
The IE or FF detector
Hello Friends,Problem of today ( we seek for php help ) as following ,we know all that PNG images not shown well on IE6 and some "css'ers" given us a solution --> fine 1but if that
Creating a function
Basically i wanna put all this code in a seperate file Code: <?php $query = "select product.ProductID, product.ProductName, product.ProductCategory,
Session variable help
I'm having a very troubling issue. Maybe I'm just looking over something but I have looked at the code for several hours now, making small adjustments here and there to try to fix this problem.
