title: displaying data from two mysql tables in dreamweaver php
body: <p>Here are my two mysql table with code and output</p>
  
  <p><a href="http://i.stack.imgur.com/casYk.jpg" rel="nofollow">casestatic table</a><a href="http://i.stack.imgur.com/7kRWZ.jpg" rel="nofollow">display records output</a></p>
  
  <p>Case Date table is like this.:</p>
  
  <pre><code> 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);
  &lt;p&gt;Cause List for Advocate: &lt;?php echo $row_AdvUser['FullName']; ?&gt; for Date: &lt;?php echo $row_casedate['NextDt']; ?&gt;&lt;/p&gt;
        &lt;table width="600" border="1"&gt;
          &lt;tr&gt;
            &lt;td&gt;File No.&lt;/td&gt;
            &lt;td&gt;Case Title&lt;/td&gt;
            &lt;td&gt;Client Side&lt;/td&gt;
            &lt;td&gt;Court Name&lt;/td&gt;
            &lt;td&gt;Case Type&lt;/td&gt;
           &lt;/tr&gt;
          &lt;tr&gt;
            &lt;td&gt;          &lt;?php echo $row_casedate['FileNo']; ?&gt;&lt;/td&gt;
            &lt;td&gt;            &lt;?php echo $row_CaseStatic['CaseTitle']; ?&gt;&lt;/td&gt;
            &lt;td&gt;            &lt;?php echo $row_CaseStatic['ClientSide']; ?&gt;&lt;/td&gt;
            &lt;td&gt;            &lt;?php echo $row_CaseStatic['CourtName']; ?&gt;&lt;/td&gt;
            &lt;td&gt;  &lt;?php echo $row_CaseStatic['CaseType']; ?&gt;&lt;/td&gt;
            &lt;/tr&gt;
        &lt;/table&gt;
  </code></pre>
  
  <p>The record displayed is only one for a particular date. I want to display all records of that particular date and particular advuser.   These code are generated in dreamweaver cs6 for php files. Please guide and help</p>