PHP: display in "Today" only, not in "Yesterday" too
<pre><code>$today = time() - (3600*24);
$Yday = time() - (3600*48);

$getMsgsToday = mysql_query("SELECT * FROM users_msgs WHERE uID = '$USER' AND date &gt; $today");
$countToday = mysql_num_rows($getMsgsToday);

$getMsgsYday = mysql_query("SELECT * FROM users_msgs WHERE uID = '$USER' AND date &gt; $Yday");
$countYday = mysql_num_rows($getMsgsYday);
</code></pre>

<p>This is my code for displaying messages latest 24 hours and 48 hours(yesterday).</p>

<p>I got two while for the queries(yesterday and today). </p>

<p>Now if you have something within 24 hours, it will also display in the yesterday while().</p>

<p>I only wish to show yesterday´s messages, with this I mean the 24 hours before today´s 24 hours.</p>

<p>How can I do this, so I dont get these duplicates?</p>
