- $q="select neurons.synapse_created,node_content,users.login,nodes.* from neurons left join nodes on neurons.src=nodes.node_id left join users on nodes.node_creator=users.user_id left join node_content on node_content.node_id=nodes.node_id where dst='$node_id' and link='bookmark' $time order by synapse_created $orderby";
- $result=$db->query($q);
- while ($result->next()) {
- $array=$result->getRecord();
- $array['node_status']="linked";
- $array['node_vector']=$node['node_vector'].";".$node['node_id'];
- $array['node_created']=$array['synapse_created'];
- $get_linked_bookmarks[]=$array;
- }
- $smarty->assign('get_linked_bookmarks',$get_linked_bookmarks);
- }
-?>
\ No newline at end of file