Search options (Page 4 of 4)

<?php
function kortaner($str, $length) {
    return ((strlen($str) > $length)?(substr($str, 0, $length)."..."):($str));
}
$dbhost = "host";
$dbuser = "username";
$dbpass = "password";
$databas = "databas";
mysql_connect($dbhost, $dbuser, $dbpass);
mysql_select_db($databas);
$querys = array("senastetopics" => "SELECT id,subject,poster FROM punbb1topics ORDER BY posted DESC LIMIT 0, 5",
        "aktivatopics" => "SELECT id,subject,poster,last_post_id FROM punbb1topics ORDER BY last_post DESC LIMIT 0, 5",
        "senasteposts" => "SELECT id,message,topic_id,poster FROM punbb1posts ORDER BY posted DESC LIMIT 0, 5",
        "senasteusern" => "SELECT id,username FROM punbb1users ORDER BY registered DESC LIMIT 0, 1",
        "senastaktivausern" => "SELECT id,username FROM punbb1users ORDER BY last_post DESC LIMIT 0, 1",
        "danews" => "SELECT punbb1topics.poster, punbb1topics.subject, punbb1topics.posted, punbb1posts.message FROM punbb1topics JOIN punbb1posts ON punbb1topics.id = punbb1posts.topic_id WHERE forum_id = 14 ORDER BY posted DESC"
        );

foreach($querys as $k => $q) {
    $query = mysql_query($q);
    while($tmp = mysql_fetch_assoc($query)) {
    $resultat[$k][] = $tmp;
    }
    //$antal[$k] = mysql_num_rows($query);
}
?>

<?php

echo "<br><br>";
echo "senaste topics<br>";

foreach($resultat['senastetopics'] as $bleh) {
    echo "<a href=\"forum/viewtopic.php?id={$bleh['id']}\" target=\"main\">".kortaner($bleh['subject'], 28)."</a><br>\n";
}

echo "<br><br>";
echo "aktiva topics<br>";


foreach($resultat['aktivatopics'] as $bleh) {
        echo "<a href=\"forum/viewtopic.php?id={$bleh['id']}\" target=\"main\">".kortaner($bleh['subject'], 20)."</a><br>\n";
}

echo "<br><br>";
echo "sentaste posts<br>";

$length = 20;
foreach($resultat['senasteposts'] as $bleh) {
    echo "<a href=\"forum/viewtopic.php?id={$bleh['topic_id']}#${bleh['id']}\" target=\"main\"><b>{$bleh['poster']}:</b> ".kortaner($bleh['message'], 18)."</a><br>\n";
}


echo "<br><br>";
echo "senaste usern: <b><a target=\"main\" href=\"forum/profile.php?id={$resultat['senasteusern'][0]['id']}\">{$resultat['senasteusern'][0]['username']}</a></b><br>\n";
echo "senast akriva usern: <b><a target=\"main\" href=\"forum/profile.php?id={$resultat['senastaktivausern'][0]['id']}\">{$resultat['senastaktivausern'][0]['username']}</a></b><br>\n";
?>

<?php
include 'dbinfo.php'
?>

<?php
include 'finfo.php
?>