I've made a simple guestbook mysql/php page. An entry is displayed if the approve column has a value of 1. For the adminstrator, I want to display either "message approved" or "not approved". Here's my code:

while ($row = mysql_fetch_array ($r)) {
    print "<p>Guest:" .$row['name']. "</p>
        <p>Date:" .$row['date']. "</p>
        <p>Comment:". $row['comment']. "</p>";

if ($row['approve'] = '1') { 
    print '<p>YES, the message has been approved</p>';
} else { 
    print '<p>NO, it hasn\'t been approved</p>';
}

Whatever value the if statement checks approve is equal to, all approve values are output as that value.