$query = "SELECT title, content, edit from news"; $result = mysql_query($query); while(mysql_num_rows($result)) { $row = mysql_fetch_array($result); $title = $row['title']; $content = $row['content']; $edit1 = $row['edit']; if($edit1 !== 'n') { $edit = 'This article has been edited.'; } echo "
$title
$content
$edit"; }