Explode doesn't work

[NLCJ]

Hello,

I've been working on some stuff, and get the information parsed like this:

Value1,Value2,Value3 0.68,4377.54,11069.02

So I'm trying to explode it and insert the latest numbers into the database. I'm using:

$value = explode(",", $variable);
$secondsplit = explode(" ", $value[2]);
mysql_query("INSERT INTO table(row) VALUES('".mysql_real_escape_string($secondsplit[1])."')");

The problem is that it has something like an enter in the database, or a space. But I can't figure out how to get rid of that problem. Does anyone know what's wrong?

 

Regards,

NLCJ

[NLCJ]

This is in the source code if I print it:

0.68

I've got no idea what it is?! It isn't a <br> or a space or a \r\n...

Maybe important: I fetch the information using cURL.

[taquitosensei]

should it be this

$string="Value1,Value2,Value3 0.68,4377.54,11069.02"
$exp1=explode(" ", $string);
$fields=explode(",", $exp1[0]); 
$values=explode(",", $exp1[1]); 
mysql_query("INSERT INTO table(row) VALUES('".mysql_real_escape_string($values[0])."')"); // 1 if you want the 2nd value, 2 if you want the 3rd 

[NLCJ]

Doesn't work, somehow there is an 'enter' but I'm not able to explode it...

[NLCJ]

I might have a clue, I think it's the 'invisible character'... What dumbass invented that?!

[PFMaBiSmAd]

You should almost always use trim on data to eliminate white-space characters surrounding it.

[NLCJ]

Thanks a lot, really! This took me about 9 hours of searching before I figured out that there is an invisible character!

 

Once again thanks!