function getMyStatsUid($uid) {
$str = “select * from commentry
where uid=’” . $_REQUEST[‘uid’] . “’”;
$this->result = $this->query($str);
while($this->getRow()){
if($this->getField(‘eventid’)){
$id.= $this->getField(‘eventid’).’,’;
}else{
$id.= $this->getField('eventid').',';
}
}
$id;
$ids= trim($id,',');//die;
// $str = "SELECT * FROM `add_event` where id IN($ids) order by id DESC" and "SELECT * FROM `commentry` where uid IN($uids) order by uid DESC";
$str = "SELECT id, eventname, detail, `sport`, `datetime` FROM `add_event` where id IN($ids) order by id DESC" UNION "SELECT eventid, uid, comment, normalpoint, fancypoint
FROM commentry
where uid=’" . $_REQUEST[‘uid’] . “’”;
$this->result = $this->query($str);
}