Hi Fenor,
Thanks for the suggestion. I hadn't tried that, but I did just now and I still have the same problem.
When I upgraded to PHP 4.2.1 I noticed that it was compiled with some different options. I don't have a copy of what they were before the upgrade. Would there be any specific option that should have been included at the time of compilation?
Would it help to reload certain perl modules? If yes, which ones?
I used the /scripts/easyapache to upgrade, and I just used the Beginner option when prompted. Any other ideas? I also installed the Zend Optimized 1.3.0, and the newest version of Curl.
??? :p
BTW... Here is the script my client is using, and has been using for some time now. It broke after we upgraded PHP:
&head&
&title&Florida Assisted Living Affiliation Data Load&/title&
&/head&
&body&
&p& &h3&Load Test Data for FALA Member Search&/h3&&p&
&?php
$hostname=&localhost&;
$username=&fhca_rita&;
$password=&******&;
$db = mysql_pconnect($hostname, $username, $password);
if ($db == false) {
$error = mysql_errno();
$errmsg = mysql_error();
printf(&Hello, did not connect!!!!&br&$error $errmsg&

;
} else {
$result = mysql_select_db(&fhca_org&,$db);
if ($result == false) {
$error = mysql_errno();
$errmsg = mysql_error();
printf(&Hello, did not select!!!!&br&$error $errmsg&

;
} else {
$result = mysql_query(&load data local infile \&fala.txt\& replace into table fala fields terminated by \&;\&&,$db);
if ($result == false) {
$error = mysql_errno();
$errmsg = mysql_error();
printf(&Hello, did not load!!!!&br&$error $errmsg&

;
}
}
}
$result = mysql_query(&select facid from fala&,$db);
if ($result == false) {
$error = mysql_errno();
$errmsg = mysql_error();
printf(&&br&Hello, did not count!!!!&br&$error $errmsg&

;
printf(&&

;
} else {
$rows = mysql_num_rows($result);
printf(&&br& $rows&

;
}
?&
&/body&
&/html&