Hi, I found a solution, I make a complaint directly into the database, if it can help someone;) $query = "SELECT vqh_node.nid, vqh_node.title, vqh_node.created AS vqh_node_created_created FROM vqh_node vqh_node LEFT JOIN vqh_term_node vqh_term_node ON vqh_node.nid = vqh_term_node.nid LEFT JOIN vqh_term_data vqh_term_data ON vqh_term_node.tid = vqh_term_data.tid WHERE (vqh_term_node.tid = '$term->tid') ORDER BY vqh_node_created_created DESC LIMIT 0,1"; Da Costa Alcindo -----Message d'origine----- De : development-bounces@drupal.org [mailto:development-bounces@drupal.org] De la part de Da Costa Alcindo Envoyé : mercredi, 4. juin 2008 14:18 À : development@drupal.org Objet : Re: [development] With the Tid get last node I already use a view to retrieve all term id, and now I would like to just doing research to find the first Nest good category. -----Message d'origine----- De : development-bounces@drupal.org [mailto:development-bounces@drupal.org] De la part de Doug Green Envoyé : mercredi, 4. juin 2008 13:11 À : development@drupal.org Objet : Re: [development] With the Tid get last node use views for this select block, return 1 node filter by taxonomy sort by created date DESC Da Costa Alcindo wrote:
Hi,
I am currently developing a module that displays a block with the last article in each category. Is what someone has already sought to retrieve the last article from a tid?
With a function like taxonomy_get_last_node($tid) ??
Cheers,
Da Costa Alcindo
-- Doug Green douggreen@douggreenconsulting.com 904-583-3342 Bringing Ideas to Life with Software Artistry and Invention...