rendered paste bodypublic function loadAll()
{
$sql = "SELECT *
FROM `help_category`";
$result = mysql_query($sql);
if (!$result)
{
echo "Could not successfully run query ($sql) from DB: " . mysql_error();
exit;
}
$helpCategories = array();
if (empty($result))
{
echo "No rows found";
// HelpCategories array remains empty
}
else
{
while ($row = mysql_fetch_assoc($result))
{
//construct a new HelpCategory
$helpCategory = new HelpCategory($row["help_category_id"], $row["name"]);
@@ print_r($helpCategory);
// add new HelpCategory to arary
$helpCategories[$i++]->$helpCategory;
@@ print_r($helpCategories[$i]);
}
}
// release database resources
mysql_free_result($result);
// return retrieved HelpCategories
return $helpCategories;
}