Hej
Ber om ursäkt för att det är ganksa mycket kod men jag kan inte riktigt hitta ver felet är. Koden i sig fungerar men inte riktigt som jag vill så jag vet inte riktigt vart jag ska leta. Felet yttrar sig genom att datumet en nyhet är skapad inte hamnar under nygheten om det är två eller fler nyheter med bilderi inslagda. Lite svårt att för klara men titta här så syns felet tydligt. Skulle bli jätteglad om någon har möjlighet att hjälpa mig.
echo "<br><p class=\"date\">".$r['createdate'].", ".$r['fullname'];
Raden ovan är den raden som skriver ut informationen som hamnar fel.
<?PHP
function shortString($string, $num) {
return trim(preg_replace ("/([^\s]+)$/", "", substr ($string, 0, $num)));
}
if(empty($_GET['id'])) {
$curdate = date("Ymd");
$sql1 = "SELECT News.id AS id, News.headline AS headline, News.content, " .
"DATE_FORMAT(News.createdate, '%Y-%m-%d') AS createdate, " .
"News.stopdate AS stopdate, User.fullname AS fullname, " .
"News.picture_id as pic_id " .
"FROM News, User " .
"WHERE $curdate >= " . 'startdate' .
" AND " . $curdate . " <= " . 'stopdate' .
" AND News.author_username = User.username ".
"ORDER BY startdate DESC";
$strQuery = mysql_query($sql1) or die(mysql_error());
echo "<table border=\"0\">";
while ($r = mysql_fetch_array($strQuery)) {
if(!empty($r['pic_id'])) {
$sql2 = "SELECT Files.id, Files.filename, Files.type " .
"FROM News, Files " .
"WHERE Files.id = News.picture_id AND News.id = '".$r['id']."'";
$strQuery2 = mysql_query($sql2) or die(mysql_error());
$rs = mysql_fetch_array($strQuery2);
echo "<div class=\"firstPageArticleContent\"> <img src=\"admin/pictures/".$rs['filename']."\" width=\"150\" height=\"100\" align=\"right\"><br>";
}
echo "<div class=\"firstPageArticleHeader\">" . $r['headline'] . "</div>";
//HTML-taggar
$r['content'] = str_replace("<", "<", $r['content']);
$r['content'] = str_replace(">", ">", $r['content']);
//Fixar till radbrytningar
$r['content'] = str_replace("\n","<br />", $r['content']);
//"Forumkoder"
$r['content'] = str_replace("[b]","<b>", $r['content']);
$r['content'] = str_replace("[/b]","</b>", $r['content']);
$r['content'] = str_replace("[i]","<i>", $r['content']);
$r['content'] = str_replace("[/i]","</i>", $r['content']);
$r['content'] = str_replace("[u]","<u>", $r['content']);
$r['content'] = str_replace("[/u]","</u>", $r['content']);
$r['content'] = preg_replace("/\[url=([^]]+)]([^[]+)\[\/url]/",
"<a href=\"\\1\" target=\"_blank\">\\2</a>",
$r['content']);
if(strlen($r['content']) > 150) {
echo shortString($r['content'], 150)."...";
echo "<img src=\"/images/blank.gif\" height=\"6\" width=\"1\"><br>";
echo "<a href=\"index.php?id=" . $r['id'] . "\" class=\"toolBoxLink\">Läs mer>></a></div>";
}
else {
echo $r['content'];
echo "<img src=\"/images/blank.gif\" height=\"6\" width=\"1\"><br>";
}
echo "<br><p class=\"date\">".$r['createdate'].", ".$r['fullname'];
}
}
else {
$curdate = date("Ymd");
$sql1 = "SELECT News.id AS id, News.headline AS headline, News.content, " .
"DATE_FORMAT(News.createdate, '%Y-%m-%d') AS createdate, " .
"News.stopdate AS stopdate, User.fullname AS fullname, " .
"News.picture_id AS pic_id " .
"FROM News, User " .
"WHERE id = " . $_GET['id'] .
" AND News.author_username = User.username " .
"ORDER BY startdate DESC";
$strQuery = mysql_query($sql1) or die(mysql_error());
echo "<table border=\"0\">";
while ($r = mysql_fetch_array($strQuery)) {
if(!empty($r['pic_id'])) {
$sql2 = "SELECT Files.id, Files.filename, Files.type " .
"FROM News, Files " .
"WHERE Files.id = News.picture_id AND News.id = '".$r['id']."'";
$strQuery2 = mysql_query($sql2) or die(mysql_error());
$rs = mysql_fetch_array($strQuery2);
echo "<div class=\"firstPageArticleContent\"> <img src=\"admin/pictures/".$rs['filename']."\" width=\"150\" height=\"100\" align=\"right\"><br>";
}
//HTML-taggar
$r['content'] = str_replace("<", "<", $r['content']);
$r['content'] = str_replace(">", ">", $r['content']);
//Fixar till radbrytningar
$r['content'] = str_replace("\n","<br />", $r['content']);
//"Forumkoder"
$r['content'] = str_replace("[b]","<b>", $r['content']);
$r['content'] = str_replace("[/b]","</b>", $r['content']);
$r['content'] = str_replace("[i]","<i>", $r['content']);
$r['content'] = str_replace("[/i]","</i>", $r['content']);
$r['content'] = str_replace("[u]","<u>", $r['content']);
$r['content'] = str_replace("[/u]","</u>", $r['content']);
$r['content'] = preg_replace("/\[url=([^]]+)]([^[]+)\[\/url]/",
"<a href=\"\\1\" target=\"_blank\">\\2</a>",
$r['content']);
echo "<div class=\"firstPageArticleHeader\">".$r['headline']."</div>";
echo $r['content'];
//echo "<a class=\"readMore\" href=\"index.php?id=".$r['id']."\" title=\"Test\">".$r['content']."</a>";
echo "<img src=\"/images/blank.gif\" height=\"6\" width=\"1\"><br>";
echo "<br><p class=\"date\">".$r['createdate'].", ".$r['fullname'];
echo "<br>";
echo "<a href=\"javascript:history.go(-1)\">Tillbaka</a>";
}
}