View Single Post
(#19)
marketingsolutions marketingsolutions is offline
Junior Member
marketingsolutions is on a distinguished road
 
Posts: 18
Join Date: Sep 2006
Location: Ilfracombe - England
Send a message via Skype? to marketingsolutions
Default 10-09-2006, 11:57 AM

Hi Maffo

I think that by changing your code slightly this will work but i would have to have a catsearch and template for each category the code is below

$sSQL="SELECT id,name,cOrder FROM ".PREFIX."categories WHERE parent_id=1000 AND display <>'N' ";
$result = $db->query($sSQL);
$tree=array();
while ($rs = $result->fetch())
{
array_push ($tree,$rs);
}

Is this correct or will this cause problems?

Regards

Stuart