$connect_id=mysql_connect($host,$user,$pass);
mysql_select_db("test",$connect_id);
$result=mysql_query("select * from user_profile");
while($data=mysql_fetch_array($result))
{
echo $data["email"]."<br>";
}没有调试过,不过大体上就是这样.