Hallo,
habe was gefunden was gehen sollte, aber irgendwie nicht bei mir, kann mal jemand gucken?
<?php
$host = "localhost"; // Host
$user = ""; // DB User
$database = "burning board lite"; // DB Name
$pass = ""; // DB Passwort
$prefix = "bb1_"; // DB Präfix
$path = "
http://localhost/temp/wbb/wbblite/"; // Pfad zur index.php
$connect = mysql_connect($host, $user, $pass) or die ("Es konnte keine Verbindung
zur Datenbank hergestellt werden");
mysql_select_db($database, $connect) or die ("Die Datenbank existiert nicht");
$sql = "SELECT `post_subject`,`post_id` FROM `".$table_prefix."posts_text` WHERE post_subject != '' ORDER BY `post_id` DESC LIMIT 5";
$result = mysql_query($sql) or die(mysql_error());
if ($result) {
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
print('<a href="'.$path.'thread.php?threadid='.$row['post_id'].'" target="_blank">'.$row['post_subject'].'<br />');
}
}
?>