try to parse the csv file line by line and you won't have memory problems
ever:
===
$d = \t; // fields delimiter
$fp = fopen ($file_name, r);
while ($arr_row = fgetcsv ($fp, 4096, $d, )) {
do_something ($arr_row);
}
fclose ($fp);
===
Mysql_fetch_assoc() is faster -- use it. I've learned something.
Using your script and postgres, with PGSQL_ASSOC in fetch_array:
fetch_assoc(): 1.62810707092 seconds [18880 rows](105580.0.52192900 :
105578.89)
fetch_array(): 1.54432892799 seconds [18880 rows](105582.0.06938900 :
You can do:
while ($row = $result-fetchRow(DB_FETCHMODE_ASSOC))
{
extract ($row);
echo $feild_A . 'nbsp';
$row = $result-fetchRow(DB_FETCHMODE_ASSOC);
extract ($row);
echo $feild_A . 'br /';
}
Tiberiu
- Original Message -
From:
Try:
if ($_GET['login'] == 'forgot')
- Original Message -
From: OpenSource [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 29, 2003 7:38 AM
Subject: [PHP-DB] weird php error
Hi guys,
This is weird to me..
I got this script
Try:
$sql = select * from item where \bib#\ = 300;
- Original Message -
From: Jeremy Peterson [EMAIL PROTECTED]
To: PHP DB [EMAIL PROTECTED]
Sent: Wednesday, August 06, 2003 4:34 AM
Subject: [PHP-DB] Sybase Query- Problems with Pound Sign
I am having a problem with a query that has
You have to do:
foreach ($test as $group) {
if (strtolower ($group) != $sort) {
$lgroup = strtolower ($group);
echo a href=\patterns.php?sort={$lgroup}\{$group}/abr /;
} else {
echo {$group}BRBR;
... query db and show results ...
echo BR;
}
}
