$query = "SELECT * FROM $usertable ORDER BY $date_field DESC"; $result = mysql_query($query); if($result) { while($row = mysql_fetch_array($result)) { $user = $row['$user_field']; $date = $row["$date_field"]; $title = $row["$title_field"]; $story = $row["$story_field"]; echo $user; }