SqlHelper::execute_dql2 PHP Method

public function execute_dql2($sql){

$arr=array(); 
$res=mysql_query($sql,$this->conn) or die(mysql_error());

//把$res=>$arr 把结果集内容转移到一个数组中.
while($row=mysql_fetch_assoc($res)){
$arr[]=$row;
}
//这里就可以马上把$res关闭.
mysql_free_result($res);
return $arr;

}

 public function showMessageByPage($fenyePage, $loginname)
 {
     $sql = "select *from message where getter = '" . $loginname . "'" . "limit " . $fenyePage->pageSize * ($fenyePage->page - 1) . "," . $fenyePage->pageSize;
     $sqlHelper = new SqlHelper();
     $res = $sqlHelper->execute_dql2($sql);
     return $res;
 }