Okay, i've got this:
$phpbb_conn=mysql_connect
("localhost", USERNAME, PASSWORD
) or die
('I cannot connect to the database because: ' . mysql_error
(
)
);
mysql_select_db
(DATABASENAME
) or die
(mysql_error
(
)
);
$getPosts = mysql_query
("select a.post_time, b.topic_title from phpbb_posts as a, phpbb_topics as b where a.topic_id = b.topic_id order by a.post_time desc limit 3", $phpbb_conn
);
print
("<p>"
;
while
($row = mysql_fetch_array
($getPosts, MYSQL_ASSOC
)
){
print
("<a href=\"forum/viewtopic.php?t=".$row['topic_id']."\" target=\"_top\">".$row['topic_title']."</a><br>"
;
}
print
("</p>"
;
Now, that works apart from the link. Any ideas?
(i'm new to MySql
)
Edited by chazco 2006-03-08 4:44 PM