[PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
7;.$sql2.''.mysql_error()); Results of this queries : In first case (it works) : I see the id get in mysql and it delete it after In second case (it don't work) : I don't see id get in mysql. It's like if it delete it first and after select. I have not error in php log

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
At the begining $var is $_GET['id'] and after I try directly $var = 10 but no changes. On the server directly, I can only try with the values : $sql = 'SELECT * FROM table WHERE id="10" '; and for this no problem. The problem is when I use a variable in query Be

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, I have print and it's OK, the query is good like if I put the value directly in the query Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com/ SIPROSSII 847 route de Frans (Créacité) 69400 Villefranch

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, No changes :/ I have always the same things Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com/ SIPROSSII 847 route de Frans (Créacité) 69400 Villefranche sur Saône Le Wed, 3 Sep 2008 11:29:29 +0200

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, string(40) "SELECT * FROM table WHERE id=107 " string(3) "107" string(38) "DELETE FROM table WHERE id=107 " string(3) "107" Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://ww

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, No error for mysql_error for all 2 queries. In fact the first return 0 results Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com/ SIPROSSII 847 route de Frans (Créacité) 69400 Villefranche sur Saône

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com/ SIPROSSII 847 route de Frans (Créacité) 69400 Villefranche sur Saône ID is INT. It's ok before. I have errors : Warning: Wrong parameter coun

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, string(0) "" int(1) string(0) "" int(1) string(0) "" int(1) Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com/ SIPROSSII 847 route de Frans (Créacité) 69400 Villefranche su

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, array(2) { ["module"]=> string(12) "sousdomaines" ["deleteid"]=> string(3) "133" } Note : The ID is good deleted but no select return Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, I Have now : string(3) "134" int(0) Lunch... NOT, I haven't the time today :p but cheese and sausage is good :) Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com/ SIPROSSII 847

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, Are you sur it is 3 ? it is 134 no? Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com/ SIPROSSII 847 route de Frans (Créacité) 69400 Villefranche sur Saône Le Wed, 3 Sep 2008 14:17:59 +0200 "

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, Humm with this query I have forgotten to tell you the ID is DELETED Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com/ SIPROSSII 847 route de Frans (Créacité) 69400 Villefranche sur Saône Le Wed, 3

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, Yes record exist before the query and is deleted after Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com/ SIPROSSII 847 route de Frans (Créacité) 69400 Villefranche sur Saône Le Wed, 3 Sep 2008 14:24

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, No, I must test a little more, I tell in few minutes Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com/ SIPROSSII 847 route de Frans (Créacité) 69400 Villefranche sur Saône Le Wed, 3 Sep 2008 20

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, I have always the problem, select = 0 rows and it delete it like if delete is before the select :/ Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com/ SIPROSSII 847 route de Frans (Créacité) 69400

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, Yes I'm using this query and no row select Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com/ SIPROSSII 847 route de Frans (Créacité) 69400 Villefranche sur Saône Le Wed, 3 Sep 2008 20:43:25

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, PHP 5.2.6 on FreeBSD 7.0 i386 associate with apache 2.0.63 Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com/ SIPROSSII 847 route de Frans (Créacité) 69400 Villefranche sur Saône Le Wed, 3 Sep 2008

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, Yes DELETE is executed and I have on my page : string(3) "140" int(0) Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com/ SIPROSSII 847 route de Frans (Créacité) 69400 Villefranche sur Saône

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, It was difficult, I have many files in includes, I will try to execute this code before in the php execution to see what code give problem. I try this now and I tell you the results of investigations Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, Humm if I go on page index.php?deleteid=139 it works If I click on the link I have the SELECT problem I will be crazy Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com/ SIPROSSII 847 route de Frans

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, The problem come from the in the input submit With text It works It is very Space Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com/ SIPROSSII 847 route de Frans (Créacité) 69400 Villefranche sur

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, I have make this to have a button, it's an error, it's the first time I have a problem with this. I'm sorry to have get your time. Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com/