public function getEdito()
{
$sql[] = "SELECT content.*, creator.name as name_creator, modificator.name as name_modificator";
$sql[] = " FROM content";
$sql[] = " LEFT JOIN user AS creator ON (content.id_user_creation = creator.id)";
$sql[] = " LEFT JOIN user AS modificator ON (content.id_user_modification = modificator.id)";
$sql[] = " WHERE content.edito=1";
return $this->daoTemplate->queryForObject(implode("\n", $sql), new ContentRowMapper());
}
public function get($id)
{
$sql = "SELECT * FROM static_content WHERE id=:id";
return $this->daoTemplate->queryForObject($sql, new StaticContentRowMapper(), array(':id' => $id));
}