5) { $arrUrl = explode("?", $strUrl); $strUrl = $arrUrl[0]; $arrUrl = explode("&", $strUrl); $strUrl = $arrUrl[0]; $query_eb = "SELECT * FROM " . $ebrochure . "_accounts WHERE purl='$strUrl'"; $eb = mysql_query($query_eb, $channel1media) or die(mysql_error()); $row_eb = mysql_fetch_assoc($eb); $totalRows_eb = mysql_num_rows($eb); if ($totalRows_eb > 0) { $firstname = $row_eb["FirstName"]; $lastname = $row_eb["LastName"]; $isRealPurl = true; if ($row_eb["id"]>4442) { if ($row_eb["Rep"] != "") { $rep = $row_eb["Rep"]; } } $updateSQL = "UPDATE " . $ebrochure . "_accounts SET hits=hits+1 , `lasttime`='$thetime' WHERE `purl`='$strUrl'"; $Result1 = mysql_query($updateSQL, $channel1media) or die(mysql_error()); } else { $aname = explode(".", $strUrl); $firstname = str_replace("_", " ", $aname[0]); if (count($aname)>1) { $lastname = str_replace("_", " ", $aname[1]); } else { $lastname = ""; } } } // } ?>