Problema ir sekojosa, nerada pareizu laiku un teksta title no foruma iet aiz ramisa paredzeta kur jabut tam visam.
Paradisu ar piemeriem:
Tagad: 02:00 - Sveix, ka iet? ko dari?
Vajag lai ir taa: 02:00 - Sveix, ka...
Un laiks ari bisu laiku rada tikai ka 02:00 bet isto laiku kad pievieno, vai ieraksta taja tema, nerada :(
Pats skripts:
<?php
// Noradi datus
$host = "localhost"; // db hosts
$dbname = "forum"; // DB
$dbuser = "root"; // db useris
$dbpass = ""; // db parole
?>
<?php
$platums = "100"; // platums (px)
$forums = "/f/"; // foruma url
$limits = "7"; // cik posti uzraadiisies
$link = mysql_connect($host, $dbuser, $dbpass)
or die("Nesanaaca piekonekteeties: " . mysql_error());
mysql_select_db($dbname) or die("Datubaze neekstiste");
mysql_query("SET NAMES UTF-8"); // NEAIZTIEC
$kverisdivi = mysql_query("SELECT posts, last_poster_name, last_poster_id, title, tid, forum_id, last_post FROM ibf_topics ORDER BY last_post DESC LIMIT ".$limits."");
echo "<div>";
while($row = mysql_fetch_array( $kverisdivi )) {
$datums = $row['start_date'];
$piev_datums = date("H:i",$datums);
echo "<p><b>$piev_datums - </b> <a style='text-decoration: none' href=\"$forums/index.php?showtopic=".$row[tid]."&view=getnewpost\" title=\"\">".$row[title]."</a><br></p>";
}
echo "</div>";
?>