Sorry the previous post got sent prematurely.
It does work, however, the problem is in the
fwrite($fp, "$rsITEMS->Fields('item_id')\n");
what gets written to the file is exactly "$rsITEMS->Fields('item_id')" for
as many records are return when I want the value to be inserted in the file.
I've also tried echo $rsITEMS->Fields('item_id'), but then that is returned
exactly that was as well.
Here's the code again:
<?php
//LOOP THROUGH RECORDSET
while (!$rsITEMS->EOF) {
//CREATE CSV
//OPEN DUMP FILE
$fp = fopen("./dump.sql", "w");
//WRITE DATA TO DUMP
fwrite($fp, "$rsITEMS->Fields('item_id')\n");
//LOOP
$rsITEMS->MoveNext();
}
//CLOSE FILE
fclose($fp);
?>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
