dbconnect.php

<?php

/* pconnect for newbies */
mysql_pconnect('localhost', 'root', '')
  or die(mysql_error());
mysql_select_db('mooddatabase')
  or die(mysql_error());

?>

view.php

<?php

$result = mysql_query("select * from users");

while($users=mysql_fetch_array($result)){
  echo $users['username'];
}