Mail Room";
$sConn = mysql_connect($dbServer, $dbUser, $dbPass)
or die("Couldn't connect to database server");
$dConn = mysql_select_db($dbDatabase, $sConn)
or die("Couldn't connect to database $dbDatabase");
if ($_GET['statustop'] != "")
$status = $_GET['statustop']; // this be the real magic
else if ($_GET['status'] != "")
$status = $_GET['status']; // this be the real magic
else $status = "";
if (isset($_GET['search']))
$searchperson = trim($_GET['search']); // this be the real magic
else if (isset($search)) $searchperson = trim($search);
else $searchperson = "";
//select from database all the referers
if ($status == "Active")
$dbQuery = "SELECT COUNT(*) AS numrows FROM mailinglist WHERE (Name LIKE '%" . $searchperson . "%' || Address1 LIKE '%" . $searchperson . "%' || Coupon LIKE '%" . $searchperson . "%') AND `status` = 'Active';";
elseif ($status == "Inactive")
$dbQuery = "SELECT COUNT(*) AS numrows FROM mailinglist WHERE (Name LIKE '%" . $searchperson . "%' || Address1 LIKE '%" . $searchperson . "%' || Coupon LIKE '%" . $searchperson . "%') AND `status` = 'Inactive';";
elseif ($status != "")
$dbQuery = "SELECT COUNT(*) AS numrows FROM mailinglist WHERE (Name LIKE '%" . $searchperson . "%' || Address1 LIKE '%" . $searchperson . "%' || Coupon LIKE '%" . $searchperson . "%' || userID LIKE '%" . $searchperson . "%') AND `deliveryStatus` = '" . $status . "';";
else
$dbQuery = "SELECT COUNT(*) AS numrows FROM mailinglist WHERE Name LIKE '%" . $searchperson . "%' || Address1 LIKE '%" . $searchperson . "%' || Coupon LIKE '%" . $searchperson . "%' || userID LIKE '%" . $searchperson . "%';";
//echo $dbQuery;
$result = mysql_query($dbQuery) or die("Couldn't get the Contacts");
$row = mysql_fetch_array($result);
$nume = $row['numrows'];
if(!isset($start)) { // This variable is set to zero for the first page
$start = 0;
}
$eu = ($start - 0);
$limit = 100; // No of records to be shown per page.
$this1 = $eu + $limit;
$back = $eu - $limit;
$next = $eu + $limit;
?>
";
$i=0;
$l=1;
for($i=0; $i<$nume; $i=$i+$limit){
if($i <> $eu){
echo " $l ";
}
else { echo "$l";
}
/// Current page is not displayed as link and given font color red
$l=$l+1;
}
echo "