Forum Moderators: coopster

Message Too Old, No Replies

Database class problem

         

Gamemaniak

12:46 pm on Nov 6, 2010 (gmt 0)

10+ Year Member



Well I just started learning to use classes in PHP. But now I'm running into some problems. I'm using a MySQL Database class and I want to use this one in my News class. It says there is an SQL error when I use 'function query'.

class News

<?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;
}

}

}

?>


class Database
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;
}

chrisranjana

2:22 pm on Nov 13, 2010 (gmt 0)

10+ Year Member



Can you post the exact SQL error ?