Product Category tree

[yogendramishra]

Hello friends,
i am creating a product catelog tree with multilevel hierarchi.I am using tree class and inside that i want to show the category tree. But it is showing errors to me. I have also created a dblib file to access sql quries. The error it is showing in this only. So i am unable to fetch data from database.Here is tree class fucntion where i m fetching data
function tep_has_category_subcategories($category_id) {
$child_category_query = db_query("select count(*) as count from categories where parent_id = '" . (int)$category_id . "'");
$child_category = db_fetch_array($child_category_query);

if ($child_category['count'] > 0) {
return true;
} else {
return false;
}
}
and here is db_query code which is stored in dblib file and excatly error is here
function db_query($query, $debug=false, $die_on_debug=true, $silent=false) {

global $DB_DIE_ON_FAIL, $DB_DEBUG;

if ($debug) {
echo "<pre>" . htmlspecialchars($query) . "</pre>";

if ($die_on_debug) die;
}

$qid = mysql_query($query);

if (! $qid && ! $silent) {
if ($DB_DEBUG) {
echo "<h2>Can't execute query</h2>";
echo "<pre>" . htmlspecialchars($query) . "</pre>";
echo "<p><b>MySQL Error</b>: ", mysql_error();
} else {
echo "<h2>Database error encountered</h2>";
}

if ($DB_DIE_ON_FAIL) {
echo "<p>This script cannot continue, terminating.";
die();
}
}

return $qid;
}
in the bold line it is showing err

[ronverdonk]

The error it is showing in this only

What error exactly is displayed and after what piece of code???
And what is the content of $query in your mysql_query??

Ronald :cool: