File Upload .xls Issue

cqball2000

I upload a .xls file. I then parse the file and query the database based on a field value in the .xls file. Here's what happens when I print the $sql statement:

SQL: select part_number from inventory where (part_number='ÐÏà¡±á')

Why is the part_number looking this way? Is it binary, or what can I do to fix it in my script?

Thanks,
Dave

dstockto

What are you using to parse the .xls file? Usually these are mostly binary stuff.

Dave

cqball2000

Something like this:

//open and read csv file
$row = 1;
$fp = fopen ("$the_file_name","r");
while ($data = fgetcsv ($fp, 1000, ",")) {
$num = count ($data);
print "<p> $num fields in line $row: <br>";
$row++;
print "$data[0],$data[1]\n";
}

This help?

Thanks.

dstockto

Are you reading from an .xls file, or a comma separated file then?

Dave