ben pas geleden begonnen met object-oriented programming en loop vast.
<?php
public function categories()
{
$sql1 ="
SELECT c.id, c.name, c.description, c.position,
(SELECT count(t.id)
FROM topics as t
WHERE t.parent=c.id and t.id2=0) as topics,
(SELECT count(t2.id)
FROM topics as t2
WHERE t2.parent=c.id and t2.id2!=0) as replies
FROM categories as c
GROUP BY c.id
ORDER BY c.position ASC
";
$result1 = mysqli_query($this->reg, $sql1);
$numrows1 = mysqli_num_rows($result1);
/*while ($row=....)
{
echo $row['cat'];
}
*/
}
?>
dit zit in mn object, maar ik moet die while in mn html hebben en niet in mn object dus:
<?php
$forum = new forum;
$categories = $forum->categories();
foreach ($categories as $category) {
echo '<span>' . $category['name'] . '</span>';
}
?>
dit werkt niet
mn class werkt gewoon en als ik de while loop in mn object werkt het ook gewoon, kan iemand me verder helpen?
groetjes