while løkke skal stoppe ved 100
jeg har en løkke her som indsætter nogle rækker i en tabel... hvordan kan jeg få den til at stoppe ved 100??$i = 1;
$exceed_time = $TIME - (60 * 60 * 24 * 30);
$sql = "SELECT track.*, SUM(user_top5.points) AS points
FROM $DB.eb_track track
LEFT JOIN $DB.eb_user_top5 user_top5 ON track.id=user_top5.track_id
WHERE user_top5.time>$exceed_time
GROUP BY track.id
ORDER BY points DESC";
$get = mysql_query($sql);
while($row = mysql_fetch_array($get))
{
if($row['points'])
{
$row2 = mysql_fetch_array(mysql_query("SELECT * FROM $DB.eb_hitlist WHERE track_id=$row[id]"));
if($row2['peak_position'] && $row2['peak_position'] < $i) $peak_position = $row2['peak_position'];
else $peak_position = $i;
if($row2['position']) $last_week = $row2['position'];
else $last_week = 0;
$move = $i - $last_week;
$weeks = $row2['weeks'] + 1;
mysql_query("INSERT INTO $DB.eb_hitlist SET
track_id=$row[id],
position=$i,
move=$move,
last_week=$last_week,
weeks=$weeks,
peak_position=$peak_position,
points=$row[points],
time=$TIME")or die(mysql_error());
$i++;
}
else mysql_query("DELETE FROM $DB.eb_track WHERE id=$row[id]");
}
