PHP使用select语句在SQL中打印表

Question

在程序中，我想创建表格以 (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";
}

Answer 1

错误原因是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";