The code looked promising but it didn’t work.
Here is what i am trying to do. I start off by marking leads with a client id. I put in some specif info and than i select the client id. I than print out the results on the screen with only so many selected. After the number is selected they should be marked with a Y for used to where they will not be used any longer. The only item i am trying to get to work is the emails i select to be marked as used so i can not use them again. Also the ID is an auto increment field so it is never empty or null.
Here is the full code:
<?php
global $email_cnt ;
$email_cnt=$_POST["email_cnt"];
global $campaign ;
$campaign=$_POST["campaign"];
$file = 'export';
//`email_cnt` = '$email_cnt'
//$sql="UPDATE comm_report SET `date` = '$date', `product` = '$product', `client_name` = '$client_name', `comm_check` = '$comm_check', `resid_check` = '$resid_check', `check_num_comm` = '$check_num_comm', `check_num_resid` = '$check_num_resid', `client_id` = '$client_id', `website_name` = '$website_name'
//WHERE `crid` = '$crid'";
?>
<?php
// $con = mysql_connect("localhost","glennn_admin","olno5893");
$con = mysql_connect("campaign2.db.5271833.hostedresource.com","campaign2","Taker3160");
// $con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("campaign2", $con);
// mysql_select_db("glennn_eric", $con);
$id = $_POST['id'];
//$demo = $_POST['demo'];
$demo = (!empty($_POST['demo']) && $_POST['demo'] == 'N') ? 'N' : 'Y';
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php
$result = mysql_query("SELECT campaign FROM campaign WHERE campaign='$id'");
while ($row = mysql_fetch_array($result)) {
$title = $row['campaign'];
}
?>
<title><?php echo $title; ?></title>
<link rel="stylesheet" href="print.css" type="text/css" media="print" />
<style type="text/css">
<!--
#font {
font-family:Lucida Console;
font-size:12px;
}
#center {
float:left;
width:500px;
text-align:right;
font-family:Lucida Console;
font-size:12px;
}
#left {
float:left;
margin-left:0px;
text-align:left;
padding-right:0px;
font-family:Lucida Console;
font-size:12px;
}
#left2 {
clear:left;
width:250px;
margin-left:0px;
text-align:left;
padding-right:0px;
font-family:Lucida Console;
font-size:12px;
}
#left3 {
float:left;
margin-left:0px;
text-align:left;
padding-right:0px;
font-family:Lucida Console;
font-size:12px;
}
#right {
float:left;
width:150px;
text-align:left;
font-family:Lucida Console;
font-size:12px;
}
#clr {
clear:both;
height:15px;
}
-->
</style>
</head>
<body>
<div align="right"><form><input type="button" value=" Print this page "
onclick="window.print();return false;" /></form> </div>
<div id="main" class="print">
<!--<div align="right"><a href="javascript:windows.print()">Print</a></div>-->
<!--
<input name="id" type="hidden" value="<?php echo $id ?>" />
-->
</div>
</div>
<div id="clr" style="clear:both; height:15px;" class="print"></div>
<div id="left" class="print"> General Statistics</div>
<?php
$result = mysql_query("SELECT * FROM campaign WHERE campaign='$id'");
while ($row = mysql_fetch_array($result)) {
?><br />
<br />
<div id="left" class="print"> Campaign Name: </div>
<div id="left2" class="print"> <span class="font"><?php echo $row["campaign"]; ?></span></div>
<div id="clr" class="print"></div>
<div id="clr" class="print"></div>
<div id="left" class="print">Campaign Link: </div>
<div id="left2" class="print"> Link to newsletter that was sent</div>
<div id="clr" class="print"></div>
<div id="clr" class="print"></div>
<div id="left" class="print">Email Subject: </div>
<div id="left2" class="print"> Slash Business Expenses!</div>
<div id="clr" class="print"></div>
<div id="clr" class="print"></div>
<div id="left" class="print">Campaign sent by admin user: </div>
<div id="left2" class="print"> admin </div>
<div id="clr" class="print"></div>
<div id="clr" class="print"></div>
<div id="left" class="print">Email List sent to: </div>
<div id="right" class="print"><?php echo $row["email_list"]; ?></div>
<div id="clr" class="print"></div>
<div id="clr" class="print"></div>
<div id="left" class="print">Start Time: <?php echo $row["tstart"]; ?></div>
<div id="clr" class="print"></div>
<div id="clr" class="print"></div>
<div id="left" class="print">Finish Time: <?php echo $row["tfinish"]; ?></div>
<div id="clr" class="print"></div>
<div id="clr" class="print"></div>
<div id="left" class="print">Campaign ID: <?php echo $row["campaign_id"]; ?></div>
<div id="clr" class="print"></div>
<div id="clr" class="print"></div>
<div id="left" class="print">The Total Recipients: <?php echo $row["total"]; ?> download information to file</div>
<div id="clr" class="print"></div>
<div id="clr" class="print"></div>
<div id="left" class="print">The total who should receive this email if
sending is successful: <?php echo $row["total"]; ?></div>
<div id="clr" class="print"></div>
<div id="left" class="print">The total rejected recipients: 0Download information
to file/Download with server messages/Send</div>
<div id="clr" class="print"></div>
<div id="left" class="print">Percent who received mailing: 99%</div>
<div id="clr" class="print"></div>
<div id="left" class="print">Forward to a friend clicked: 0</div>
<div id="clr" class="print"></div>
<div id="clr" class="print"></div>
<div id="clr" class="print"></div>
<div id="clr" class="print"></div>
<div id="clr" class="print"></div>
<div id="clr" class="print"></div>
<div id="left" class="print"> Read Ratio Statistics (HTML emails only)</div>
<div id="clr" class="print"></div>
<div id="left" class="print">Unique recipients who read email: <br /><?php echo $row["unique_recp"]; ?></div>
<div id="clr" class="print"></div>
<br />
<div id="left" class="print">Read Ratio Percentage:
<?php
$result = mysql_query("SELECT * FROM campaign where campaign='$id'");
while($ejw = mysql_fetch_array($result))
{
$a = $row['unique_recp']/$row['total'];
echo round($a,5)."%";
}
?>
</div>
<div id="clr" class="print"></div>
<div id="clr" class="print"></div>
<div id="left" class="print">Number of times email was opened: <?php echo $row["emails_opened"]; ?></div>
<div id="clr" class="print"></div>
<div id="clr" class="print"></div>
<div id="left" class="print">Un-Subscribes:
<?php echo $row["unsubscribes"]; ?></div>
<div id="clr" class="print"></div>
<div id="clr" class="print"></div>
<div id="left" class="print">Bounces: <?php echo $row["bounces"]; ?></div>
<div id="clr" class="print"></div>
<div id="clr" class="print"></div>
<div id="clr" class="print"></div>
<div id="clr" class="print"></div>
<div id="clr" class="print"></div>
<div id="clr" class="print"></div>
<div id="left" class="print"> Link Statistics (Click column to sort field)</div> <br />
<div id="left" class="print"> Domain name Clicks from this mailing
Total clicks from this campaign
Download/Send Subscribers
<br /> Download/Send:Total clicks:2:2:</p>
</div>
<div id="clr" class="print"></div>
<div id="clr" class="print"></div>
<div id="clr" class="print"></div>
<div id="clr" class="print"></div>
<div id="left" class="print"> Most read recipients Top
<?php echo $row["unique_recp"]; ?>
(HTML Emails Only)</div>
<div id="clr" class="print"></div>
<div id="clr" class="print"></div>
<div class="print" id="font">
<?php
$limit = $row["unique_recp"];
}
$res = mysql_query("SELECT emails FROM email_list WHERE custid = '$id' and demo = 'N' LIMIT $limit");
while ($row = mysql_fetch_array($res))
{
echo "<div id=\"left\">".$row['emails']."</div><div id=\"clr\"></div>";
}
$res2 = mysql_query("update email_list set demo = 'Y' WHERE custid = '$id' LIMIT $limit");
mysql_query($res2. mysql_error());
mysql_close($con);
?>
</div>
<div id="clr" class="print"></div>
<div id="clr" class="print"></div>
<div id="clr" class="print"></div>
<div id="clr" class="print"></div>
<div id="left" class="print"> Download all subscribers who read this email</div>
<div id="clr" class="print"></div>
<div id="left3" class="print">Send email to all subscribers who read this email</div>
<div id="clr" class="print"></div>
<div id="clr" class="print"></div>
<div id="left3" class="print">Download all subscribers who did NOT read this email</div>
<div id="clr" class="print"></div>
<div id="left3" class="print">Send email to all subscribers who did NOT read this email</div>
</div>
<br />
<br />
<br />
</body>
</html>The Area i am having issues with is this bit of code:
<?php
$limit = $row["unique_recp"];
}
$res = mysql_query("SELECT emails FROM email_list WHERE custid = '$id' and demo = 'N' LIMIT $limit");
while ($row = mysql_fetch_array($res))
{
echo "<div id=\"left\">".$row['emails']."</div><div id=\"clr\"></div>";
}
$res2 = mysql_query("update email_list set demo = 'Y' WHERE custid = '$id' LIMIT $limit");
mysql_query($res2. mysql_error());
mysql_close($con);
?>
Everything else is working. I need the update to mark all selected emails as “Y” for being used.