Sort CSV rows into HTML pages

[RinEn]

Hi, I'm having a problem with sorting rows from a csv file, where I would like to have the latest line of data appended to the csv file to be displayed as the topmost line in the HTML page. How do I do that with the fgetcsv function?

Here's my current code :

$row =0;
$tmpdata="";
$handle = @fopen("course_db.csv", "rb") or die("Couldn't open file");

echo "<TABLE WIDTH='1195' BORDER='1' BORDERCOLOR='#CCCCCC' CELLSPACING='0' CELLPADDING='3' >";

while ($data = fgetcsv ($handle, 1000)) {
$num = count ($data);
$row++;
echo "<TR VALIGN='TOP'><TD ALIGN='LEFT' WIDTH='25'>" . $row . "</TD>";

        for ($c=0; $c <$num; $c++) {
   $tmpdata = $data[$c];
   if(($c == 0) || ($c == 11)) {
        $tmpdata = preg_replace("/\&\&/", "<br>", $tmpdata); 
                } echo "<TD ALIGN='LEFT' WIDTH='90'>";

       echo $tmpdata ."</TD>";
       }echo "</TR>";

}echo "</TABLE>";

fclose ($handle);

[OhLordy]

Two ways I can think of. You could a) read the whole file into an array and then cycle back through this.

<?php
$file='course_db.csv';
$fh=@fopen($file,'rb') or die('Could not open '.$file.'<br />\n');
for($i=0;$dat1=fgetcsv($fh,1000);$i++) {
  $data[]=$dat1;
}
?>
<table>
<?php
for($i=count($data)-1;$i>=0;$i--) {
  <tr>
    <td><?=count($data)-$i?></td>
<?php
  for($j=0;$j<count($data[$i]);$j++) {
?>
    <td><?=$data[$i][$j]?></td>
<?php } ?>
  </tr>
<?php } ?>
</table>
?>

HTH
Rob

[RinEn]

ahhh.. didn't know earlier that I could use this :
for($i=0;$dat1=fgetcsv($fh,1000);$i++)

Thanks for the great help!! 😃