Ave,

I'm trying to retrieve data from a DBF database and write it to a CSV file in a comma delimited format. I'm able to get the data and write it to CSV, but it only writes the last row/record ... not all the records. I know I don't have the correct code and I'm hoping someone can help me...


_____________
#CREATE CSV
$date = date('mdy');
$_file = 'CSV/TransferData_'.$date.'.csv';
$_fp = @fopen( $_file, 'w' );

        #SELECT DBF TO OPEN - READ ONLY
        $db = dbase_open("mydata.dbf", 0);
        #PULL UP RECORD
        if ($db) {
          $record_numbers = dbase_numrecords($db);
          for ($i = 1; $i <= $record_numbers; $i++) {
                $row = dbase_get_record_with_names($db, $i);
                
                #WRITE ROWS TO VARIABLE
$_csv_data = trim($row['PHONE']).",".trim($row['DATE']).","."\n"; <-- THIS is where my problem is! This only writes the last row!!
          }
        }

#WRITE TO CSV   
@fwrite( $_fp, $_csv_data );
@fclose( $_fp );
_____________

Thanks!

---
Rahul Sitaram Johari
Founder, Internet Architects Group, Inc.

[Email] sleepwal...@rahulsjohari.com
[Web]   http://www.rahulsjohari.com





--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to