Page is running slow!

1

Could someone please help me??

I’ve made a tabel in php that corresponds with a mysql database.Now the problem is that it is running very slow. Maybe because i used a wrong loop or is it the query that i’m using?
I only want to show de last 14 rows of de database because it contains much more but i don’t want to show that.

I’m using the following code:


<?php
// Connect naar de server and select een database
$link = mysql_connect("blablabla") or die ("could not connect");
mysql_select_db ("blablala") or die ("could not select database");
// Voer Sql query uit
$query= "SELECT * FROM blablabla GROUP BY id DESC LIMIT 14";
$result_handle = mysql_query($query) or die ("Query failed");
/*
Print het resultaat in een HTML tabel
Eerste benadering: krijg het resultaat als een associatief array
*/
print "<table bgcolor='white' width='100%' cellSpacing=0 cellPadding=1 border=0 align='left'>

<th bgcolor='363636' width='5'></th>
<th bgcolor='363636' width='100' align='center'><font color='ffffff'>DATUM</font></th>
<th bgcolor='363636' width='5'></th>
<th bgcolor='363636' width='100' align='left'><font color='ffffff'>ARTIEST</font></th>
<th bgcolor='363636' width='95' align='left'><font color='ffffff'>TITEL</font></th>
<th bgcolor='363636' width='100' align='left'><font color='ffffff'>STEMMEN</font></th>
<th bgcolor='363636' width='40'><font color='ffffff'>VS.</font></th>
<th bgcolor='363636' width='5'></th>
<th bgcolor='363636' width='100' align='left'><font color='ffffff'>ARTIEST</font></th>
<th bgcolor='363636' width='95' align='left'><font color='ffffff'>TITEL</font></th>
<th bgcolor='363636' width='100' align='left'><font color='ffffff'>STEMMEN</font></th>
<th bgcolor='363636' width='100' align='center'><font color='ffffff'>WINNAAR</font></th>
<th bgcolor='363636' width='5'></th>
<tr height='5'>

</tr>

";
$teller = 1;
while ($row =  mysql_fetch_array($result_handle,MYSQL_ASSOC)){
if ($teller % 2 == 1) {
print "<tr bgcolor='e6e6e6'>
";
} else {
print "<tr bgcolor='ffffff'>
";
} 
$teller++; 
// lees alle velden van deze rijen uit de database
$datum = $row["datum"];
$artiesteerste = $row["artiest1"];
$titeleerste = $row["titel1"];
$stemmeneerste = $row["stemmen1"];
$plaatjeerste = $row["plaatje1"];
$artiesttwee = $row["artiest2"];
$titeltwee = $row["titel2"];
$stemmentwee = $row["stemmen2"];
$plaatjetwee = $row["plaatje2"];
$winnaar = $row["winnaar"];
// print alle velden in hun respectieve colommen van de tabel
print "<td width='5'></td>

<td bgcolor='cccccc' width='100' align='center'>$datum</td>

<td width='100' align='center'><img src= $plaatjeerste /></td>

<td width='100' align='left'>$artiesteerste</td>

<td width='95' align='left'>$titeleerste</td>

<td width='100' align='left'>$stemmeneerste</td>

<th bgcolor='ffffff' width='40'>VS.</th>

<td width='100' align='center'><img src= $plaatjetwee /></td>

<td width='100' align='left'>$artiesttwee</td>

<td width='95' align='left'>$titeltwee</td>

<td width='100' align='left'>$stemmentwee</td>

<th bgcolor='fe3baf'width='100' align='center'><font color='ffffff'>$winnaar</font></th>

<td width='5'></td>

</tr>

<tr height='5'>

</tr>
";
}//while
print "</table>
";
//close connection
mysql_close($link);
?>

Thank u very much!!