I think this strange [DB map]

Monday 21 July 2003 6:30:34 am

My old module is not working, after searching I found strange thing, when you create artical will get obj id in ezcontentobject table, also will get node id in ezcontentobject_tree table, now my module is make query from this 2 table , and the result is NULL, coz the ezcontentobject_tree.contentobject_id is not the same as ezcontentobject.id (obj id), or its not insterted to ezcontentobject_tree table !

the query is :

$db->arrayQuery( "Select ezcontentobject_tree.node_id from ezcontentobject,ezcontentobject_tree
where
ezcontentobject.contentclass_id ='$myclassid' and
ezcontentobject_tree.parent_node_id = ezcontentobject.id

");

any idea ?

thx