PHP kolejnosc wczytywania z bazy

$query  = "SELECT * FROM posty";
$result = mysql_query($query)  or die("Query failed");
  
$ile = mysql_num_rows($result);
for ($i = 1; $i <= $ile; $i++)
{

$row = mysql_fetch_assoc($result);
$nr=$row['nr'];
$tytul = $row['tytul'];
        $tresc= $row['tresc'];
$autor= $row['autor'];
$data= $row['data'];
$postID=$row['nr'];
?>

<div class="post">

<div class="tytul"><?php echo"$tytul"; ?></div>
<div class="tresc"><?php echo"$tresc"; ?></div>

<div class="data"><b>Data dodania:<?php echo"$data"; ?></b></div>
<div class="autor"><b><?php echo"$autor"; ?></b></div>

...