Comparing mysql record with current time
<p>I have a query that shows appointments that a user has made in a format year-month-day start time(00:00:00) end time(00:00:00),now i want to compare this whole format with the current time and if it is equal or higher to not show do appointment because user has the option to cancel the appointment and if the time for the appointment has passed i want to hide the cancel appointment option from him...here is my query and html echo...</p>

<pre><code>$result = mysql_query("SELECT id,date,start,end FROM jos_jxtc_appbook_appointments WHERE userident='$idusera'");
while($row = mysql_fetch_assoc($result))
{
echo '&lt;div class="record" id="record-',$row['id'],'"&gt;
    &lt;a href="?delete=',$row['id'],'" class="delete"&gt;Delete&lt;/a&gt;
    &lt;strong&gt;',$row['date'], $row['start'], $row['end'],'&lt;/strong&gt;
  &lt;/div&gt;';
}
</code></pre>
