PHP show data based on Yesterday and Today
<p>I have an question about show data table based on date. In this case I want to show data based on today and yesterday.</p>

<p>Design table :<br>
<strong>form_no | model_name | prod_status | date_added</strong></p>

<p>Example data :<br>
1 | acer | OK | 12-APR-2013<br>
2 | acer | NG | 11-APR-2013</p>

<p>So if in table I just want the data will show once, because the model name is same.
Table view Like this <br></p>

<p><strong>No | Model | Yesterday Status | Today Status</strong><br>
1 | acer | NG | OK</p>

<p>and here is my code :</p>

<pre><code>$today = date("j-F-Y");
$yesterday = date("j-F-Y, time() - 60 * 60 * 24;");

$query = "SELECT model_name, prod_status, date_added FROM t_production_status WHERE date_added like '$today%'";
$result = mysql_query($query);
</code></pre>

<p>Now I'm done show data by today in table, now I want to display yesterday status to table view.</p>
