PHP使用select语句在SQL中打印表
PHP使用select语句在SQL中打印表
提问于 2013-12-12 16:43:30
在程序中，我想创建表格来打印出(Y/M/D)格式的日期，卷，待定和发送。但是，它在执行后不会显示任何内容。它可以在SQL中使用phpmyadmin执行。但是，我不知道我们是否可以使用两个SQL语句来找出两个不同的条件。我需要你的帮助。
$start = date('2013-12-12');
$today = date("Y/m/d");
echo "Today's date: " .$today;
$result = mysql_query("SELECT count(semail) AS av FROM table WHERE `thedate`>='2013-12-12' GROUP BY `thedate` ")or die(mysql_error());
$row = mysql_fetch_assoc($result) or die("No rows returned by query");
$totalofemail = $row['av'];
$sent = mysql_query("SELECT count(semail) AS av FROM table WHERE `sflag`='1' AND `thedate`>='2013-12-12' GROUP BY `thedate`")or die(mysql_error());
$result = mysql_fetch_assoc($sent) or die("No rows returned by query");
$sentemail = $result['av'];
$pending = $totalofemail - $sentemail;
echo "<table border='1'>
<tr>
<th>Date</th>
<th>Daily volume</th>
<th>Sent</th>
<th>Pending</th>
</tr>";
if($i=0; $i<($today-$start); $i++)
{
echo "<tr>\n";
echo "<td>" . $row['thedate'] . "</td>\n";
echo "<td>" . $totalofemail . "</td>\n";
echo "<td>" . $sentemail . "</td>\n";
echo "<td>" . $pending . "</td>\n";
echo "\n</tr>\n";
echo "</table>\n";
}回答 2
Stack Overflow用户
回答已采纳
发布于 2013-12-12 16:45:39
错误的原因是if($i=0; $i< ($today-$start); $i++)
但在您的代码中，不需要使用for循环
尝试使用，
for($i=0; $i< ($today-$start); $i++)而不是
if($i=0; $i< ($today-$start); $i++)代码:删除循环条件。因为循环不是必需的。
$start = date('2013-12-12');
$today = date("Y/m/d");
echo "Today's date: " .$today;
$result = mysql_query("SELECT count(semail) AS av FROM mycard WHERE `thedate`>='2013-12-12' GROUP BY `thedate` ")or die(mysql_error());
$row = mysql_fetch_assoc($result) or die("No rows returned by query");
$totalofemail = $row['av'];
$sent = mysql_query("SELECT count(semail) AS av FROM mycard WHERE `sflag`='1' AND `thedate`>='2013-12-12' GROUP BY `thedate`")or die(mysql_error());
$result = mysql_fetch_assoc($sent) or die("No rows returned by query");
$sentemail = $result['av'];
$pending = $totalofemail - $sentemail;
echo "<table border='1'>
<tr>
<th>Date</th>
<th>Daily volume</th>
<th>Sent</th>
<th>Pending</th>
</tr>";
echo "<tr>\n";
echo "<td>" . $row['thedate'] . "</td>\n";
echo "<td>" . $totalofemail . "</td>\n";
echo "<td>" . $sentemail . "</td>\n";
echo "<td>" . $pending . "</td>\n";
echo "\n</tr>\n";
echo "</table>\n";页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/20538660
复制相关文章
相似问题
腾讯云开发者
