kayasax | joce a écrit a écrit :
utilise la fonction REPLACE de MySQL...
Par exemple :
INSERT INTO latable (champ) VALUES (REPLACE("tonnombre",",","." ));
Exemple :
mysql> CREATE TABLE test (test float(2,2) NOT NULL default '0');
Query OK, 0 rows affected (0.03 sec)
mysql> INSERT INTO test (test) VALUES (REPLACE("4,2",",","." ));
Query OK, 1 row affected (0.00 sec)
mysql> SELECT * FROM test;
+------+
| test |
+------+
| 4.20 |
+------+
1 row in set (0.00 sec) |
|
Merci joce ! finalement je suis reparti sur php : un petit "$duree=ereg_replace(",",".",$duree);" avant de valider le form ---------------
All we need is a soul revolution
|