[insert_php] $dbhost = 'internal-db.s130672.gridserver.com'; $dbuser = 'db130672_query'; $dbpass = 'aardvark'; $zip = $_REQUEST['zip']; if ($zip == null) { $zip = ""; } if (!is_numeric($zip)) { $zip = ""; } $conn = mysql_connect($dbhost, $dbuser, $dbpass); if(! $conn ) { die('Could not connect: ' . mysql_error()); } $sql = "SELECT `t_code`, `zip`, `e_mail`, `active`, `owner`, `street`, `city`, `state`, `phone`, `tname` FROM `territories` \n" . "WHERE Active=1 \n"; if ($zip != "") { $sql = $sql."AND zip='".$zip."'"; } else { $sql = $sql ."AND 1=0"; } mysql_select_db('db130672_inquiry'); $retval = mysql_query( $sql, $conn ); if (! $retval ) { die('Could not get data: ' . mysql_error()); } $row = mysql_fetch_array($retval, MYSQL_ASSOC); if ($row) { print "Your local Auto Appraisal Network Certified Appraiser is: "; print "

".$row['owner']."

"; print "Based in ".$row['city'].", ".$row['state']." ".$row['zip']." "; print "Phone: ".$row['phone']." "; print "E-Mail: ".$row['e_mail']." "; } else { print "No Appraisers found for this Zip Code: ".$zip; print " Search Again"; } [/insert_php]