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
removing space from the end of a variable
i have a variable $image which contains the following url "http://tiles.xbox.com/tiles/oo/P5/0mdsb2JgbA9ECgR8GgMfWSpVL2ljb24vMC84MDAwIAABAAAAAP3Wg70=.jpg"but for some reason it is breaking
php mailer
How can i send a mail to large no, say 50,000 reciepients using [color=#0000FF]php mailer[/color]
How to read posted binary data from a mobile device and post it to a web server?
Here is the senario...I have a mobile device (MD) that posts binary data to a Web Server (WS1) and that Web Server (WS1) posts that binary data (from the MD) to another Web Server (WS2).(MD)
How to limit the calls to an API
Hello, in my simple script I call an api which effectively involves me getting an xml file.However the problem is everytime I get a visitor to the webpage it calls the API which means lots of wasteful
ereg_replace()
Basically what i need to do is $title = "This Suck's"$striped = ereg_replace("[^A-Za-z0-9]", " ", $title ); However, I only want it to strip the " ' "
background color imagefill
HelloI would like to ask you why I see this square in red color just in my local xampp installation. If I run the code in the remote server (http://www.arreglaordenador.com/numberimage2.php) I see the
Error In Syntax
I got this error:Code: Parse error: syntax error, unexpected '>' in /home/bucket/public_html/inc/func.ban.php on line 56<?phperror_reporting(E_ALL);ini_set('display_errors', '1');//
Credit card verification
I have a client who wants to process credit card transactions from his web site rather than the going through something like paypal. I've never done that before...what is my first step? I really dont
Trouble with a select list
Hello All! I was wondering if any of you guys could help me with a small problem I'm having!I'm trying to add a select list to a form on my webpage.The select list is generated from information
CURL XML Request [From C to PHP]
Hi, I need some help converting this into something that will work with PHP.Code:
