How to compare your dates in database mysql?

[rolyestemonio]

I have a problems of comparing dates in mysql.Can anyone help me out?
the codes goes like this:

function getlocal()
                      {
$sql = mysql_query("SELECT * FROM tbl_localnews");
$result = $sql;
return $result;
                      }

 <?php
							$result = getlocal();
							$new = $result[0]['dates'];
while($row = mysql_fetch_array($result)){
$news = $row['dates'];
if ($row['dates'] isEqual ){

...display by dates

}else{
..they will diplay another date.
							?>

Your help is highly appreaciated guys..thanks

[code green]

A number of points.
This is PHP not MySql.
You haven't defined the problem.
What dates are you trying to compare?