<?php 
$data=mysql_query("select username,status from users where status='yes';");
print "<ul>";
while($info=mysql_fetch_array($data)){
$user=$info['username'];
print "<li>".$user."</li>";
}
print "</ul>";
?>