Forum Moderators: coopster
<?php
class News extends Database {
private function getCategory() {
$returnArray = null;
$qsubcat = $this->query("SELECT
*
FROM
news_subcat");
while($fsubcat = mysql_fetch_array($qsubcat)) {
$returnArray[] = $fsubcat;
}
return $returnArray;
}
public function setCategory() {
$returnStr = null;
$categoryDatasource = $this->setCategory();
if(is_array($categoryDatasource)) {
foreach($categoryDatasource as $categoryArray) {
$returnStr.= '<option value="'.$categoryArray['subcat_id'].'">'.stripslashes($categoryArray['subcat_name']).'</option>';
}
return $returnStr;
}
}
}
?> function query($sql, $only_first = false)
{
$this->recent_link =& $this->link;
$this->sql =& $sql;
$result = @mysql_query($sql, $this->link) or $this->raise_error();
$this->query_count++;
if ($only_first)
{
$return = $this->fetch_array($result);
$this->free_result($result);
return $return;
}
return $result;
}