Wordt wel geupdated, maar wanneer ik een album toevoeg van zeg maar 14 nummers geeft ie maar de helft weer in de file.
Wil iemand even meedenken ?
Code: Selecteer alles
<style type="text/css">
<!--
body {
background-color: transparent;
width: 100%;
}
}
-->
</style><?php
require_once('../config/config.php');
echo "<center><table width=850 border='0' style='border:1px solid #AFB1B1' cellspacing='0' cellpadding='2'>";
echo " <tr bgcolor='transparent'>";
echo " <td colspan='5' background='transparent'>";
echo " <p align='center'>";
echo " <font face='Verdana, Arial, Helvetica' size='3' color='#000000'>";
echo " <b>NIEUW TOEGEVOEGD AAN ONZE PLAYLIST - RECENTLY ADDED TO OUR PLAYLIST</b>";
echo " </font>";
echo " <br>";
echo " <br>";
echo " <font face='Verdana, Arial, Helvetica' size='3' color='#000000'>";
echo " Wekelijks updaten wij onze playlist, vraag jouw nummer aan via de REQUEST button!!";
echo " <br>";
echo " <br>";
echo " <hr>";
echo " </font>";
echo " </td>";
echo " </tr>";
$select = $db->select()
->distinct(true)
->from('songlist', array('title', 'artist', 'picture','date_added', 'id', 'cnt' => 'Count(*)'))
->where('songtype = ?', 'S')
->group(array('title'))
->having('cnt > 0')
->order('date_added DESC')
->limit(35,0);
$count = 1;
$rows = $db->fetchAll($select);
foreach($rows as $row)
{
$count++;
if(($count % 2)== 0)
{
echo "<tr align='center'>";
echo " <td width=250>";
echo " <p align='left'>";
echo " <font face=Verdana color=#000000 size=3><b>ARTIST: <i></font>
<font face=Verdana color=#FF0000 size=3><i><a1 '../display/display.playlist.php?name=Playlist&?letter=". $letter . "&artist=" . rawurlencode($row["ARTIST"]) . "'>" . $row["ARTIST"] . "</a1></i></font><br>";
echo " <font face=Verdana color=#000000 size=2><b>TITLE: </b></font>
<font face=Verdana color=#999999 size=3><b><a1 '../display/display.playlist.php?name=Playlist&?letter=". $letter . "&title=" . rawurlencode($row["TITLE"]) . "&title=" . rawurlencode($row["TITLE"]) . "'>" . $row["TITLE"] . "</a1></b><font><br>";
echo " </p>";
echo " </td>";
echo "</tr>";
}
}
echo "</table>";
?>
