PHP-CSV echo results display problem

[JDJones]

I am using PHP to read a CSV file and print the output to a table. It
works fine but the output is generating an extra empty <td></td> column
at the end of each line and for the life of me I can't find where it's
coming from. I'm sure it's something little but I need help finding it.

I'm using a semi-colon as the delimiter rather than a comma.

Anyone see the problem?

PHP file:
<?php
$filename = "freadtest.txt";
$id = fopen($filename, "r");
while ($data = fgetcsv($id, filesize($filename),";"))
$table[] = $data;
fclose($id);
echo "<table width=\"100%\" border=\"5\">\n";
foreach($table as $row)
{
echo "<tr>";
foreach($row as $data)
echo "<td>$data</td>";
echo "</tr>\n";
}
echo "</table>\n";
?>

freadtest.txt:
John Smith;123 Main Street;Boston, MA 02100;12*@abc.com;
Harry Jones;666 West Central Street;Brooklyn, NY 10026;tr***@who.com;
Perry White;987 Park Drive South;Chicago,IL 60006;fa**@hotmail.com;

[CountScubula]

just a shot in the dark, but maybe becouse there is an end delimeter?

--
Mike Bradley
http://www.gzentools.com -- free online php tools
"JDJones" <se******@sprynet.com> wrote in message
news:4WFRb.128870$Rc4.995323@attbi_s54...

I am using PHP to read a CSV file and print the output to a table. It
works fine but the output is generating an extra empty <td></td> column
at the end of each line and for the life of me I can't find where it's
coming from. I'm sure it's something little but I need help finding it.

I'm using a semi-colon as the delimiter rather than a comma.

Anyone see the problem?

PHP file:
<?php
$filename = "freadtest.txt";
$id = fopen($filename, "r");
while ($data = fgetcsv($id, filesize($filename),";"))
$table[] = $data;
fclose($id);
echo "<table width=\"100%\" border=\"5\">\n";
foreach($table as $row)
{
echo "<tr>";
foreach($row as $data)
echo "<td>$data</td>";
echo "</tr>\n";
}
echo "</table>\n";
?>

freadtest.txt:
John Smith;123 Main Street;Boston, MA 02100;12*@abc.com;
Harry Jones;666 West Central Street;Brooklyn, NY 10026;tr***@who.com;
Perry White;987 Park Drive South;Chicago,IL 60006;fa**@hotmail.com;

[laidbak]

>at the end of each line and for the life of me I can't find where it's

I think you may have an empty line at the bottom of
your csv file.
____________________________________
Wil Moore III, MCP | Integrations Specialist | Senior Consultant
DigitallySmooth Inc. | Quick Site Studio

[JDJones]

JDJones wrote:

I am using PHP to read a CSV file and print the output to a table. It
works fine but the output is generating an extra empty <td></td> column
at the end of each line and for the life of me I can't find where it's
coming from. I'm sure it's something little but I need help finding it. freadtest.txt:
John Smith;123 Main Street;Boston, MA 02100;12*@abc.com;
Harry Jones;666 West Central Street;Brooklyn, NY 10026;tr***@who.com;
Perry White;987 Park Drive South;Chicago,IL 60006;fa**@hotmail.com;

CountScubula wrote: just a shot in the dark, but maybe becouse there is an end delimeter?

Removing that end semi-colon from the text lines was the answer. It now
displays as it should. I was under the (now mistaken) impression that
the semi-colon was needed at the end of all the fields.

Thank you, Mike. That's why I love this newsgroup. I'm always learning
something new. :)