[melin]

$posters = explode(",", "Camilla K,Camilla S,Cizzi,Emiliee,Emma,Emmy,Jonna,Karro,Katarina,Maria");

$i = 0;
while ($i < count($posters)):
	$strDbName = str_replace(" ", "", strtolower($posters[$i]));
	echo "<h2>" . $posters[$i] . "</h2>";
	$query="SELECT blog_" . $strDbName . "_posts.*, blog_" . $strDbName . "_categories.*, blog_" . $strDbName . "_post2cat.* FROM blog_" . $strDbName . "_posts inner join blog_" . $strDbName . "_post2cat on blog_" . $strDbName . "_post2cat.post_id = blog_" . $strDbName . "_posts.ID inner join blog_" . $strDbName . "_categories on blog_" . $strDbName . "_post2cat.category_id = blog_" . $strDbName . "_categories.cat_ID where blog_" . $strDbName . "_posts.post_content <> '' order by blog_" . $strDbName . "_posts.post_date desc limit 0, 5";
	$result=mysql_query($query);
	$num=mysql_num_rows($result);
//   	echo "<small style=\"font-size: 8px;\"><em>".$query."</em></small><br />";
	mysql_close();
	$j=0;
	while ($j < $num) {
 $categoryLink=mysql_result($result,$j,"category_nicename");
 $categoryName=mysql_result($result,$j,"cat_name");
 $postTitle=mysql_result($result,$j,"post_title");
 $postLink=mysql_result($result,$j,"post_name");
 
 echo "<a href=\"$strDbName/$categoryLink/$postLink\"><b>$postTitle</b></a><br />";
 $j++;
	}
	$result = "";
	$i++;
endwhile;

Info

Den går igenom alla felfritt - men.. kör bara den första query-förfrågan. $num resulterar inte i någonting alls fr.o.m $posters nummer 2.

Kör jag varje query i phpMyAdmin så får jag på varje minst 1 post i retur