function loadActivity($limit, $id)
{
$activities = array();
$img = new ImageDAO();
$query = "SELECT id,title,description,DATE_FORMAT(date,'%m-%Y'),price,ticketSales,scene,cat FROM activity where status='active' ";
if ($id > 0) {
$query = $query . " and id={$id}";
$imgLimit = 0;
} else {
$imgLimit = 1;
}
if ($limit > 0) {
$query = $query . " limit {$limit}";
}
$result = mysql_query($query, $this->con);
while ($row = mysql_fetch_row($result)) {
$activity = new Activity();
$activity->id = $row[0];
$activity->title = $row[1];
$activity->description = $row[2];
$activity->date = $row[3];
$activity->price = $row[4];
$activity->ticketSales = $row[5];
$activity->scene = $row[6];
$activity->category = $row[7];
$activity->images = $img->getImages($row[0], $imgLimit);
$activity->events = $this->loadEvent($row[0]);
$activities[] = $activity;
}
return $activities;
}
