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
update 2 columns by doing inner 2-column query
Hi,
Get last modified date of web page
Hai All, In php how can i get last modified date of a give web page . I have tried to get last modified from the header but for some pages the server of that webpage doesn't returns lastmodified
why does my session end?
my connect.php starts the session just so you knowi can navigate arround my site fine except when i come to this page. it lets me in but then when i try to leave no matter what page i go to or which
division gives infinity anser
int main(){ int z=0; int i=1/z; cout<<i;}It doesn't throw any error in Visual Studio 2008. .......What setting one has to change so that it will show runtime error in VS 2008.....
Day of week
I am using PHP version 5.0.5I have a varaible ($DATE (date format yyyy-mm-dd)) that is being incremented to populate a table with each day of the month. I am then trying to get the day of week
Login page problems
I developed a website a few months ago and I am now having an issue with logging into it. The place that it is hosted just did some upgrades to their servers and for some reason, now my login page
disable all input buttons
Hello Friends,suppose i do have a file ( file.php ) has a submit buttonCode: [Select]<input type=submit name=add value=go> is there any way so i can make the button shown but in same
hiCode: <?phpecho "<td width=\"$columnWidth%\" align=\"center\"><a href=\"" . $_SERVER['PHP_SELF'] .
Problem in back link
I have page where i have given javascript back link but when i click on it browser give a messageWebpage has expired
Multiple Options for a Single Page
For this example I want to use the Handlers option which is under Fed Admin and all the related coding to the handlers option is found on the handlers.php page which includes a list of handlers with a