include("1/connection.inc"); include("1/util.inc"); // include_once("forum/functions.inc.php"); $LIST_PREFIX = "l."; $_states = "Cleaning Maid Services, Interior Home Cleaning Maid Service, "; foreach($stateCode as $key => $value) { $_states.=$key.", "; } if($finished=="2"){ $sql="Select id FROM $tableCategoryShema WHERE category_id = '$categorys' AND item_id = '$category_items'"; $resu=mysql_query($sql, $my_connect); $rows=mysql_num_rows($resu); if($rows > 0) $sid = mysql_result($resu, 0, "id"); $sql="Select count FROM $tableTopSearches WHERE sxema = '$sid' AND zip = '$zipss'"; $resu=mysql_query($sql, $my_connect); $rows=mysql_num_rows($resu); if($rows > 0){ $count = mysql_result($resu, 0, "count"); $count++; $sql="UPDATE $tableTopSearches SET count = '$count' WHERE sxema = '$sid' AND zip = '$zipss' AND provider like '$webHostName'"; $resu=mysql_query($sql, $my_connect); } else { $sql="INSERT INTO $tableTopSearches (sxema, zip, count, provider) VALUES ('$sid', '$zipss', '1', '$webHostName')"; $resu=mysql_query($sql, $my_connect); } $loc = $webHostName."/l."; $sql="Select category_item_prefix as name FROM $tableCategoryItem WHERE id = '$category_items'"; $resu=mysql_query($sql, $my_connect); $rows=mysql_num_rows($resu); if($rows > 0) $name = mysql_result($resu, 0, "name"); $loc .= "$name"; $sql="Select category_prefix as name FROM $tableCategory WHERE id = '$categorys'"; $resu=mysql_query($sql, $my_connect); $rows=mysql_num_rows($resu); if($rows > 0) $name = mysql_result($resu, 0, "name"); $loc .= ".$name"; $sql="Select LastLineCity_prefix as LastLineCity, State, county_prefix as County FROM $tableZip WHERE zip = '$zipss'"; $resu=mysql_query($sql, $my_connect); $rows=mysql_num_rows($resu); if($rows > 0){ $name = mysql_result($resu, 0, "county"); $loc .= ".$name"; $name = mysql_result($resu, 0, "LastLineCity"); $loc .= ".$name"; $name = mysql_result($resu, 0, "state"); $name = str_replace(" ", " ", str_replace(" ", "_", $name)); $loc .= ".$name.$zipss"; } $loc .= ".html"; Header( "Location: ".$loc); } ?> Services Directory by - Customer Rated Prescreened Pros

prescreenedpros

| Free Business Listings | Contractors Login | About Us

PrescreenedPros is the #1 resource for finding

  Prescreened & Customer-Rated Professionals in your area! 

Links

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/proscom/public_html/1/links.inc on line 12