public function createAction()
{
$entity = new Faq();
$entity->load_from_array($this->request->getParam("faq"));
if (save_faq($entity)) {
$this->flash->setSuccess("New Question added successfully!");
$this->redirect_to(project_show_path($entity->project_id));
} else {
$this->flash->setError("There was an error saving the question. Both fields are required.");
//$this->render(array("entity" => $entity), "new");
$this->redirect_to(project_show_path($entity->project_id));
}
}
/**
Retrieves a list of Faq
@order = Optional, can be an array of keys or just a single key to order by the results
@limit = Optional
*/
function list_faq($order = null, $limit = null, $where = null)
{
global $__db_conn;
$sql = "SELECT * FROM faq";
if ($where != null) {
$sql .= " WHERE " . $where;
}
if ($order != null) {
$order_str = $order;
if (is_array($order)) {
$order_str = implode(",", $order);
}
$sql .= " order by {$order_str}";
}
if ($limit != null) {
$sql .= " limit {$limit}";
}
$result = mysql_query($sql, $__db_conn);
if (!$result) {
Makiavelo::info("Mysql error: " . mysql_error() . "::" . $sql);
}
$results = array();
while ($row = mysql_fetch_assoc($result)) {
$tmp = new Faq();
$tmp->load_from_array($row);
$results[] = $tmp;
}
return $results;
}
