Code: Select all
//Connect to database
$conn = mysql_connect($DBHOST, $DBUSER, $DBPASS, 0, 65536);
if(!$conn){
exit('Error connecting to databse'. mysql_error());
}
//Open database
$db_select = mysql_select_db($DBNAME);
if(!$db_select){
exit('Error opening to databse: '. mysql_error());
}
//Set radius variable
$radius = 10;
$zipcode = '02138';
GetNearZipCodes($zipcode, $radius);
function GetNearZipCodes($zip, $rad){
global $conn;
echo 'functions param: '.$zip.' '.$rad;
$zip = mysql_real_escape_string($zip);
$result = mysql_query("CALL GetNearbyZipCodes('{$zip}', {$rad})", $conn);
if(isset($result)){
$num_rows = mysql_num_rows($result);
if($num_rows > 7){
//reduce the size of radius
--$rad;
GetNearZipCodes($zip, $rad);
}else{
while ($row = mysql_fetch_assoc($result)){
echo '<br />'.$row[zipcode];
}//end while
}//end else
}
}
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\workspace\project3\GetZipcodes.php on line 41