phpBB.de

Pyramide hat geschrieben:

Code: Alles auswählen

SELECT p.post_id, if(length(pt.post_subject)>0, pt.post_subject, t.topic_title) AS title
FROM phpbb_posts p
JOIN phpbb_posts_text pt ON (p.post_id = pt.post_id)
JOIN phpbb_topics t ON (t.topic_id = p.topic_id)
ORDER by p.post_time DESC

Danke - wo genau muss ich das eintragen?

Hi @ all,

habe ein kleines PHP-Script, welches die letzen zehn Posts aus der Datenbank holt.

<?
$MY_HOST = "localhost";
$MY_DB_NAME = "xxx";
$MY_USER = "xxx";
$MY_PASS = "xxx";
$MY_DB_TABLE = "phpbb_posts_text";
$num_view_message = 11;


$connect = mysql_connect($MY_HOST, $MY_USER, $MY_PASS);
if ...