.txt file issue

[bufhal]

Hello;
I have been using myphpadmin to upload files to a MySQL database. When I "Insert" one record at a time, my web page dropdown menu querys work. But when I upload a .txt file-although the file appears to upload ok, the webpage querys will not work.
My hosting co mentions this advice:

The problem is in the inappropriate input file format (the txt file) - there are spaces before and after the comas.
To solve the problem - please strip the spaces arround the comas.
We do not support user script - means we would not debug scripts writen from you or any third party company. Please refer to the script author for support.

Is this something I can put in my code so I do not have to format the .txt file?
Any help is appreciated.

[drawmack]

[man]str_replace[/man]

[bufhal]

I am new to PHP and MySQL, drawmack, can you tell me what section of code I would need and where str replace would go in my webpage? I have two files: index.php and results.php.
Here is my main webpage with the dropdowns from the database:

<?php 
// Connection to the db server and select active db 
$SQLlink = @mysql_connect("", "", ""); //creates a connection
if (!$SQLlink) 
  Die("Couldn't connect to the db server."); // display error message on error 
if (!mysql_select_db("", $SQLlink))
  Die("Couldn't access database.");          // display error message on error 
// perform query 
$data   = mysql_query("SELECT date, agency, city FROM agencies");
$agencies = Array(); 
$dates = Array(); 
$cities = Array(); 
while($row = mysql_fetch_array($data)) {     // assign results into arrays 
  $dates[]    = $row["date"]; 
  $agencies[] = $row["agency"]; 
  $cities[]   = $row["city"];
} 

$dates = Array_Unique($dates);               // remove duplicate values 
$agencies = Array_Unique($agencies); 
$cities = Array_Unique($cities); 

Sort($dates);                                // sort arrays 
Sort($agencies); 
Sort($cities); 

$date_out   = "<select name='date'   onchange=\"window.open('results.php?action=date&value='+this.value, 'agencyWin', 'location=yes,left=20,top=20');\">"; 
$agency_out = "<select name='agency' onchange=\"window.open('results.php?action=agency&value='+this.value, 'agencyWin', 'location=yes,left=20,top=20');\">"; 
$city_out   = "<select name='city'   onchange=\"window.open('results.php?action=city&value='+this.value, 'agencyWin', 'location=yes,left=20,top=20');\">"; 

$date_out   .= "<option>-- select date ---</option>";
$agency_out .= "<option>-- select agency ---</option>";
$city_out   .= "<option>-- select city ---</option>"; 
forEach ($dates as $value) 
  $date_out   .= "<option value='$value'>$value</option>"; 

forEach ($agencies as $value) 
  $agency_out .= "<option value='$value'>$value</option>"; 
forEach ($cities as $value) 
  $city_out   .= "<option value='$value'>$value</option>"; 
$date_out   .= "</select>\n";
$agency_out .= "</select>\n";
$city_out   .= "</select>\n"; 
echo $date_out.""; 
echo $agency_out.""; 
echo $city_out."<BR>";

?>