[SOLVED] Ignore blank lines from text file

[Nandini]

Hi

 

I am exporting my database values in to text file while click on some link. I am getting a text file with the database values. But i am getting first line as a blank line. I have used trim() function. But no use. I want to export with out any blank lines. how can i do this?

 

Here is my code:

 

$text_dt=date("Y-m-d-H-i-s");

$file_name=$text_dt;

header('Content-type: text/plain');

header('Content-Disposition: attachment; filename="'.$file_name.'.txt"');

$sql_rate=mysql_query("select * from lcdial_rates'");

while($row=mysql_fetch_array($sql_rate))

{

echo trim($row['prefix']." ".trim($row['rate']);

}

 

pls help me out.

[taith]

while($row=mysql_fetch_array($sql_rate)){

if(empty($row[prefix])||empty($row[rate])) continue;

echo trim($row['prefix']." ".trim($row['rate']);

}

[Ken2k7]

Why not just do that in the SQL?

 

SELECT * FROM lcdial_rates WHERE prefix <> '' AND rate <> '';

[ignace]

This function already exists:

http://be.php.net/manual/en/function.file.php

 

use as:

 

<?php
$fileLines = file('filename.txt', FILE_SKIP_EMPTY_LINES);
?>

[Nandini]

Thanx for ur reply.

 

In database there no empty lines. So no need fire query as  SELECT * FROM lcdial_rates WHERE prefix <> '' AND rate <> '' and check values are empty or not.

 

And

 

I am not reading a file. just i am exporting database values into text file. That means downloading a text file. I dont have empty line in database table. but i got first line as empty in text file.

[Nandini]

Hi all

 

Problem was solved. This problem was occured about header content type.

 

Thanx for all reply.