September 20th, 2004, 01:37 PM
|
|
Registered User
|
|
Join Date: Apr 2004
Posts: 11
Time spent in forums: 2 h 6 m 33 sec
Reputation Power: 0
|
|
UPDATE: I just solved my own problem. Thank you!
Ok. I was able to grab data from the database and save it to a .txt file.
My problem is that I only want 'X' number of fields, say two fields. It has to be TAB Delimited, which it now works but It refused to break at the end of the line.
PHP Code:
while ($rows = mysql_fetch_array($result)){
$fields = mysql_num_fields($result)or die('error on line: '.__LINE__.' '.mysql_error());
$content = "";
//calc the length of the line (number of elements)
for($i = 0; $i < $fields; $i++){
if ($fields == 2) {
$content = $content . $rows[$i]."\t". "\n";
}
}//next
$content = substr($content, 0, strlen($content)-2). "\n"; //remove the last pipe as its not needed and adds the new line character
// Write $content to our opened file.
if (fwrite($handle, $content) === FALSE) {
echo "Cannot write to file ($filename)";
exit;
}
}//end while
OUTPUT: 'john marry jessica carol james julie jeff'.
DESIRED OUTPUT:
john marry
jessica carol
james julie
jeff
What am i doing wrong?
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
