在dreamweaver php中显示两个mysql表中的数据

Question

下面是我两个mysql表，其中包含代码和输出

casestatic tabledisplay records output

案例日期表如下：

 CREATE TABLE `casedt` (
  `SlNo` bigint(7) NOT NULL,
  `AdvUser` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `FileNo` int(5) NOT NULL,
  `NextDt` date NOT NULL,
  `Comments` varchar(100) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

 mysql_select_db($database_MyDatabase, $MyDatabase);
$query_casedate = sprintf("SELECT * FROM casedt WHERE AdvUser = %s", GetSQLValueString($colname_casedate, "text"));
$casedate = mysql_query($query_casedate, $MyDatabase) or die(mysql_error());
$row_casedate = mysql_fetch_assoc($casedate);
$totalRows_casedate = mysql_num_rows($casedate);
<p>Cause List for Advocate: <?php echo $row_AdvUser['FullName']; ?> for Date: <?php echo $row_casedate['NextDt']; ?></p>
      <table width="600" border="1">
        <tr>
          <td>File No.</td>
          <td>Case Title</td>
          <td>Client Side</td>
          <td>Court Name</td>
          <td>Case Type</td>
         </tr>
        <tr>
          <td>          <?php echo $row_casedate['FileNo']; ?></td>
          <td>            <?php echo $row_CaseStatic['CaseTitle']; ?></td>
          <td>            <?php echo $row_CaseStatic['ClientSide']; ?></td>
          <td>            <?php echo $row_CaseStatic['CourtName']; ?></td>
          <td>  <?php echo $row_CaseStatic['CaseType']; ?></td>
          </tr>
      </table>

显示的记录仅是特定日期的一条记录。我想要显示该特定日期和特定advuser的所有记录。这些代码是在dreamweaver cs6中为php文件生成的。请指导和帮助

Answer 1

请看这里的声明，

$row_casedate = mysql_fetch_assoc($casedate);

您仅从结果集中提取一行。删除此行并循环遍历<table>中的整个结果集，如下所示：

// your code    

<table width="600" border="1">
<tr>
  <td>File No.</td>
  <td>Case Title</td>
  <td>Client Side</td>
  <td>Court Name</td>
  <td>Case Type</td>
</tr>
<?php
    while($row_casedate = mysql_fetch_assoc($casedate)){
        ?>
        <tr>
            <td><?php echo $row_casedate['FileNo']; ?></td>
            <td><?php echo $row_CaseStatic['CaseTitle']; ?></td>
            <td><?php echo $row_CaseStatic['ClientSide']; ?></td>
            <td><?php echo $row_CaseStatic['CourtName']; ?></td>
            <td><?php echo $row_CaseStatic['CaseType']; ?></td>
        </tr>
        <?php
    }
?>
</table>

Sidenote:不要使用mysql_*函数，它们从PHP5.5开始就被弃用了，并且在PHP7.0中被完全删除了。请改用mysqli或pdo。And this is why you shouldn't use mysql_* functions。