Intet fra databasen
Hej,Jeg henter nogle blogs fra en database - hvor jeg før ikke har haft problemer, men den er nu stoppet med at hente ting ud, ved ikke helt hvorfor det pludseligt ikke virker mere, og kan ikke helt selv lige gennemskue fejlen - nogen der kan se fejl?
<div class="blog_posts">
<?php
$blog = mysql_query("SELECT object_id from ideaal_term_relationships WHERE term_taxonomy_id='3' order by object_id DESC LIMIT 0,3");
while($blog_row = mysql_fetch_array($blog))
{
$blog_id=$blog_row['object_id'];
$blog_post = mysql_query("SELECT post_date,post_title,post_excerpt from ideaal_posts WHERE ID='$blog_id' and post_status='publish'");
while($blog_post_row = mysql_fetch_array($blog_post))
{
$pic = mysql_query("SELECT * from ideaal_posts WHERE post_parent='$blog_id' and post_type='attachment' and post_title='prew'");
$pic_row=mysql_fetch_array($pic);
$pic_link=$pic_row['guid'];
IF ($pic_link == ""):
$img_link = "";
ELSE:
$img_link = "<a href='?page_id=13&blog=".$blog_id."'><img src='".$pic_link."' border='0px'></a>";
ENDIF;
setlocale(LC_TIME, 'da_DK');
$myDate = $blog_post_row['post_date'];
$date= strftime('%e. %B %Y',strtotime($myDate));
// Hvis kl skal med, så ændre strftime('%e. %B %Y',strtotime($myDate)); til strftime('%e. %B %Y kl. %T',strtotime($myDate));
// Opretter/nulstiller array til tags
$arrtest = array();
$res = mysql_query("SELECT ideaal_terms.name, ideaal_terms.slug FROM ideaal_terms INNER JOIN ideaal_term_relationships ON ideaal_terms.term_id=ideaal_term_relationships.term_taxonomy_id WHERE ideaal_term_relationships.object_id='$blog_id' and ideaal_term_relationships.term_taxonomy_id<>'1' and ideaal_term_relationships.term_taxonomy_id<>'2' and ideaal_term_relationships.term_taxonomy_id<>'3' and ideaal_term_relationships.term_taxonomy_id<>'4'");
while($rows = mysql_fetch_array($res))
{
$arrtest[] = "<a href='?tag=".$rows['slug']."&page_id=13' class='tag_link'>".$rows['name']."</a>";
}
$tags = implode(", ",$arrtest);
echo "<div class='blog'><div class='blog_title'><a href='?page_id=13&blog=".$blog_id."' class='headerlink'>".$blog_post_row['post_title']."</a></div><span class='blog_date'>".$date.", </span> <span class='blog_tag'>".$tags."</span><div class='blog_ref'>".$blog_post_row['post_excerpt']."</div><div class='prew_pic'>".$img_link."</div><div class='blog_more'><a href='?page_id=13&blog=".$blog_id."' class='nav_link'>Læs mere...</a></div></div>";
}
}
?>
<div class="blog_arkiv"><a href='?page_id=a' class='nav_link'>Arkiv</a></div>
</div>
På forhånd tak! :)
