Pulling in one item of four categories

[dc_jt]

Hi

 

Ive got an offers table which contains name, category_id

 

I want to display all offers, however the first page will only display four offers (one of each category).

 

My query is as follows so how do I do this part?

 

Thanks

 

public function GetAll($iStart = 0, $iLimit = 0, $iCategoryId)
{
	$date = date("Y-m-d");

	$sSql = "SELECT offer_id, title, description, short_description, date_posted,
		start_date, end_date, image1, image_path, download, download_path, category_id, link, ordering, display, featured
	FROM $this->sTableName 
	WHERE display = 1 &&
	featured = 0 &&
	start_date <= '$date' &&
	end_date >= '$date'";

	$sSql .= "ORDER BY ordering DESC";

	$iStart = (int) $iStart;
	$iLimit = (int) $iLimit;

	if ($iStart >= 0 && $iLimit > 0)
	{
		$sSql .= " LIMIT $iStart, $iLimit";
	}

	return mysql_query($sSql, $this->oDb->GetConnection());
}