I am working on a website which finds listings based on a zipcode and a keyword. The zipcode search extends adjacent zipcodes as well.
Code: Select all
require_once('zip_codes/zipcode.class.php');
mysql_connect('localhost','wwwgoge_gogeDB','gogetitcheaper') or die(mysql_error());
mysql_select_db('wwwgoge_gogetitcheaper') or die(mysql_error());
$zipSearch = $_GET['zipcode']; //zipcode from search form
$range = $_GET['range']; //radius in miles
$z = new zipcode_class;
$zips = $z->get_zips_in_range($zipSearch, $range, _ZIPS_SORT_BY_DISTANCE_ASC, true);
foreach ($zips as $key => $value) {
The I have a MySQL query for the keyword search
Code: Select all
// get keyword result from search
$keywordResult = $_GET['keywords'];
// search database for keywords
mysql_select_db($database_goge, $goge);
$query_keyword = "SELECT DISTINCT keyLinkId FROM keywords WHERE keywords.keyName = '$keywordResult'";
$keyword = mysql_query($query_keyword, $goge) or die(mysql_error());
$row_keyword = mysql_fetch_assoc($keyword);
$totalRows_keyword = mysql_num_rows($all_keyword);
$rowId = $row_keyword['keyLinkId'];
Code: Select all
mysql_select_db($database_goge, $goge);
$query_listings = "SELECT * FROM listings WHERE listings.liZipcode = '$key' AND listings.liLinkId = '$rowId' AND listings.liApproved = 'Y'";
$listings = mysql_query($query_listings, $goge) or die(mysql_error());
$row_listings = mysql_fetch_assoc($listings);
$totalRows_listings = mysql_num_rows($listings);