Kod:
$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 |
