Visualizzazione dei risultati da 1 a 3 su 3
  1. #1

    Selezionare solo il primo post

    Ciao ragazzi

    ho un problema tecnico. Ho un bellissimo forum targato phpBB e ho deciso che mi serve prelevare dal DB del forum solo il primo post delle ultime due discussioni aperte.
    La query che vado a fare è questa

    "SELECT "
    ."topic_title as titolo, "
    ."post_text as testo, "
    ."phpbb_topics.topic_id as id, "
    ."username as nomePoster, "
    ."topic_replies as risposte, "
    ."topic_views as visite, "
    ."topic_time as data "
    ."FROM "
    ."phpbb_topics "
    ."INNER JOIN "
    ."phpbb_users "
    ."ON "
    ."phpbb_topics.topic_poster = phpbb_users.user_id "
    ."INNER JOIN "
    ."phpbb_posts "
    ."ON "
    ."phpbb_topics.topic_id = phpbb_posts.topic_id "
    ."INNER JOIN "
    ."phpbb_posts_text "
    ."ON "
    ."phpbb_posts.post_id = phpbb_posts_text.post_id "
    ."WHERE "
    ."phpbb_topics.forum_id=87 "
    ."ORDER BY "
    ."data DESC "
    ."LIMIT 2";

    mi spiegate perchè quando vado a scrivere i dati mi spara fuori oltre che il primo post anche la risposta al post?

    Grazie a tutti

  2. #2
    "
    SELECT
    topic_title as titolo,
    post_text as testo,
    phpbb_topics.topic_id as id,
    username as nomePoster,
    topic_replies as risposte, /*Devi togliere la selezione delle risposte*/
    topic_views as visite,
    topic_time as data
    FROM phpbb_topics
    INNER JOIN phpbb_users ON phpbb_topics.topic_poster = phpbb_users.user_id
    INNER JOIN phpbb_posts ON phpbb_topics.topic_id = phpbb_posts.topic_id
    INNER JOIN phpbb_posts_text ON phpbb_posts.post_id = phpbb_posts_text.post_id
    WHERE phpbb_topics.forum_id = 87
    ORDER BY data DESC
    LIMIT 0,2
    ";

  3. #3
    Grazie mille ma purtroppo il problema permane

    $querySelNews ="SELECT "
    ."topic_title as titolo,"
    ."post_text as testo,"
    ."phpbb_topics.topic_id as id,"
    ."username as nomePoster, "
    ."topic_views as visite, "
    ."topic_time as data "
    ."FROM phpbb_topics "
    ."INNER JOIN phpbb_users ON phpbb_topics.topic_poster = phpbb_users.user_id "
    ."INNER JOIN phpbb_posts ON phpbb_topics.topic_id = phpbb_posts.topic_id "
    ."INNER JOIN phpbb_posts_text ON phpbb_posts.post_id = phpbb_posts_text.post_id "
    ."WHERE phpbb_topics.forum_id = 102 "
    ."ORDER BY data DESC "
    ."LIMIT 0,3";

    come da te suggerito ho eliminato la stringa dedicata alla selezione delle risposte ma il problema sussite.
    Qualche consiglio?
    Grazie ancora

Permessi di invio

  • Non puoi inserire discussioni
  • Non puoi inserire repliche
  • Non puoi inserire allegati
  • Non puoi modificare i tuoi messaggi
  •  
Powered by vBulletin® Version 4.2.1
Copyright © 2025 vBulletin Solutions, Inc. All rights reserved.