SQLite - PDO - double quotes escaped

[chat94]

Hello,

I'm trying SQLite 3 with PDO (i only know MySQL).

I have a field with this value :
...parler de "famille de produit"...

When i do a select request to retrieve these datas, i obtain :
$cnx->query("SELECT * FROM diffuseur_champs WHERE id_diffuseur=".$_POST['diffuseur']." ORDER BY ordre")->fetchAll()
...parler de \"famille de produit\"...

How can i have this result without \ ?

Thanks

[Nullsig]

By not inserting it into the database with the slashes.

By ensuring that magic quotes is turned off

By using stripslashes() function.

[chat94]

Ok thanks,

PHP (5.3.6) is by default with magic_quotes_gpc to 1.

Is best to put it at 0 or to use stripslashes() function on GPC datas ?

[Nullsig]

Magic quotes and global variables should be disabled.