I am having a problem of a column in the database updating off a mysql update.
here is the code i have:
Code:
<?php
global $email_cnt ;
$email_cnt=$_POST["email_cnt"];
global $campaign ;
$campaign=$_POST["campaign"];
$file = 'export';
?>
<?php
$con = mysql_connect("localhost","glennn_admin","olno5893");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
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>";
}
$demo = (!empty($_POST['demo']) && $_POST['demo'] == 'N') ? 'N' : 'Y';
$res2 = mysql_query("update email_list set demo = 'Y' WHERE custid = '$id' LIMIT $limit");
mysql_query($res2);
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>I am selecting a specific number of emails with the LIMIT $limit and once i have them on the page i need them updated to a “Y” All items are marked as “N”.
the specific area of code is this
<?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>";
}
$demo = (!empty($_POST['demo']) && $_POST['demo'] == 'N') ? 'N' : 'Y';
$res2 = mysql_query("update email_list set demo = 'Y' WHERE custid = '$id' LIMIT $limit");
mysql_query($res2);
mysql_close($con);
?>If you can think of any way of getting this to work i would appreciate it for your help. I can program in php but i am still learning how to do things properly.
Thank you