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 : d.durieux@xxxxxxxxxxxxx
Site Web : http://www.siprossii.com/
SIPROSSII
847 route de Frans (Créacité)
69400 Villefranche sur Saône
Le Wed, 3 Sep 2008 12:54:19 +0200
"Evert Lammerts" <evert.lammerts@xxxxxxxxx> a écrit:
>What does var_dump($_GET) say?
>
>On Wed, Sep 3, 2008 at 12:48 PM, David DURIEUX
><d.durieux@xxxxxxxxxxxxx> wrote:
>> Bonjour,
>>
>> The query works
>>
>> But when I wrote this :
>>
>>
>> if (isset($_GET['deleteid'])){
>>
>> $var=108;
>> $query = mysql_query("SELECT * FROM table WHERE id={$var};")
>> or die("select error: " . mysql_error());
>>
>> if ($row = mysql_fetch_assoc($query))
>> var_dump ($row);
>>
>> $query = mysql_query("DELETE FROM table WHERE id={$var}") or
>> die("delete error: " . mysql_error());
>>
>>
>> }
>>
>>
>> It not works and no return and no error .
>>
>> If I place the query you have sent me without the if it works but I
>> must have a if for delete the ID
>>
>> It is very strange
>>
>> Cordialement,
>>
>> David DURIEUX
>> Tel : 04.74.04.81.34
>> Port : 06.34.99.45.18
>> Mail : d.durieux@xxxxxxxxxxxxx
>> Site Web : http://www.siprossii.com/
>>
>> SIPROSSII
>> 847 route de Frans (Créacité)
>> 69400 Villefranche sur Saône
>>
>>
>>
>> Le Wed, 3 Sep 2008 12:39:45 +0200
>> "Evert Lammerts" <evert.lammerts@xxxxxxxxx> a écrit:
>>
>>>Fixed then?
>>>
>>>On Wed, Sep 3, 2008 at 12:39 PM, David DURIEUX
>>><d.durieux@xxxxxxxxxxxxx> wrote:
>>>> Bonjour,
>>>>
>>>> Yes I have the values
>>>>
>>>> array(5) { ["id"]=> string(3) "121" ["domaine"]=> string(1)
>>>> "1" ["sous_domaine"]=> string(8) "aaaaaaaa" ["repertoire"]=>
>>>> string(0) "" ["redirection"]=> string(1) "0" }
>>>>
>>>>
>>>> Cordialement,
>>>>
>>>> David DURIEUX
>>>> Tel : 04.74.04.81.34
>>>> Port : 06.34.99.45.18
>>>> Mail : d.durieux@xxxxxxxxxxxxx
>>>> Site Web : http://www.siprossii.com/
>>>>
>>>> SIPROSSII
>>>> 847 route de Frans (Créacité)
>>>> 69400 Villefranche sur Saône
>>>>
>>>>
>>>>
>>>> Le Wed, 3 Sep 2008 12:36:43 +0200
>>>> "Evert Lammerts" <evert.lammerts@xxxxxxxxx> a écrit:
>>>>
>>>>>I keep on making mistakes. $data should be $row in the var_dump -
>>>>>but right now your DELETE has already deleted id 17 (the fact that
>>>>>it prints NULL means the if condition was satisfied). So replace
>>>>>the below code with a different $var value:
>>>>>
>>>>>$var=107;
>>>>>$query = mysql_query("SELECT * FROM table WHERE id={$var};") or
>>>>>die("select error: " . mysql_error());
>>>>>
>>>>>if ($row = mysql_fetch_assoc($query))
>>>>> var_dump ($row);
>>>>>
>>>>>$query = mysql_query("DELETE FROM table WHERE id={$var}") or
>>>>>die("delete error: " . mysql_error());
>>>>>
>>>>>On Wed, Sep 3, 2008 at 12:33 PM, David DURIEUX
>>>>><d.durieux@xxxxxxxxxxxxx> wrote:
>>>>>> Bonjour,
>>>>>>
>>>>>> I have :
>>>>>>
>>>>>> NULL
>>>>>>
>>>>>>
>>>>>>
>>>>>> Cordialement,
>>>>>>
>>>>>> David DURIEUX
>>>>>> Tel : 04.74.04.81.34
>>>>>> Port : 06.34.99.45.18
>>>>>> Mail : d.durieux@xxxxxxxxxxxxx
>>>>>> Site Web : http://www.siprossii.com/
>>>>>>
>>>>>> SIPROSSII
>>>>>> 847 route de Frans (Créacité)
>>>>>> 69400 Villefranche sur Saône
>>>>>>
>>>>>>
>>>>>>
>>>>>> Le Wed, 3 Sep 2008 12:29:44 +0200
>>>>>> "Evert Lammerts" <evert.lammerts@xxxxxxxxx> a écrit:
>>>>>>
>>>>>>>Which means you do get results and your select works.
>>>>>>>
>>>>>>>Now try:
>>>>>>>
>>>>>>>$var=107;
>>>>>>>$query = mysql_query("SELECT * FROM table WHERE id={$var};") or
>>>>>>>die(mysql_error());
>>>>>>>
>>>>>>>if ($row = mysql_fetch_assoc($query))
>>>>>>> var_dump ($data);
>>>>>>>
>>>>>>>$query = mysql_query("DELETE FROM table WHERE id={$var}") or
>>>>>>>die(mysql_error());
>>>>>>>
>>>>>>>On Wed, Sep 3, 2008 at 12:25 PM, David DURIEUX
>>>>>>><d.durieux@xxxxxxxxxxxxx> wrote:
>>>>>>>> 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 : d.durieux@xxxxxxxxxxxxx
>>>>>>>> Site Web : http://www.siprossii.com/
>>>>>>>>
>>>>>>>> SIPROSSII
>>>>>>>> 847 route de Frans (Créacité)
>>>>>>>> 69400 Villefranche sur Saône
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Le Wed, 03 Sep 2008 05:23:19 -0500
>>>>>>>> Micah Gersten <micah@xxxxxxxxxxx> a écrit:
>>>>>>>>
>>>>>>>>>You have to pass mysql_num_rows a $result variable from your
>>>>>>>>>query.
>>>>>>>>>
>>>>>>>>>Thank you,
>>>>>>>>>Micah Gersten
>>>>>>>>>onShore Networks
>>>>>>>>>Internal Developer
>>>>>>>>>http://www.onshore.com
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>David DURIEUX wrote:
>>>>>>>>>> Bonjour,
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> Cordialement,
>>>>>>>>>>
>>>>>>>>>> David DURIEUX
>>>>>>>>>> Tel : 04.74.04.81.34
>>>>>>>>>> Port : 06.34.99.45.18
>>>>>>>>>> Mail : d.durieux@xxxxxxxxxxxxx
>>>>>>>>>> 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 count for mysql_num_rows()
>>>>>>>>>> in /usr/home/sites/CL000001/Web_data/hebergement/pages/sousdomaines.php
>>>>>>>>>> on line 7 string(0) "" NULL
>>>>>>>>>>
>>>>>>>>>> Warning: Wrong parameter count for mysql_num_rows()
>>>>>>>>>> in /usr/home/sites/CL000001/Web_data/hebergement/pages/sousdomaines.php
>>>>>>>>>> on line 12 string(0) "" NULL
>>>>>>>>>>
>>>>>>>>>> Warning: Wrong parameter count for mysql_num_rows()
>>>>>>>>>> in /usr/home/sites/CL000001/Web_data/hebergement/pages/sousdomaines.php
>>>>>>>>>> on line 16 string(0) "" NULL
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> Le Wed, 3 Sep 2008 12:11:00 +0200
>>>>>>>>>> "Evert Lammerts" <evert.lammerts@xxxxxxxxx> a écrit:
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>>> In fact the first return 0 results
>>>>>>>>>>>>
>>>>>>>>>>> So the problem is in your select, and if your select works
>>>>>>>>>>> when you manually insert the value for id (iow, without
>>>>>>>>>>> using $var), the problem has something to do with $var.
>>>>>>>>>>>
>>>>>>>>>>> Is the data type of the ID column INT? Try the following and
>>>>>>>>>>> let us know the output:
>>>>>>>>>>>
>>>>>>>>>>> $var=107;
>>>>>>>>>>> $query = mysql_query("SELECT * FROM table WHERE id={$var};")
>>>>>>>>>>> or die(mysql_error()); // make sure to use double quotes
>>>>>>>>>>> var_dump(mysql_error(), mysql_num_rows());
>>>>>>>>>>>
>>>>>>>>>>> $var=mysql_real_escape_string("107");
>>>>>>>>>>> $query = mysql_query("SELECT * FROM table WHERE id={$var};")
>>>>>>>>>>> or die(mysql_error()); // make sure to use double quotes
>>>>>>>>>>> var_dump(mysql_error(), mysql_num_rows());
>>>>>>>>>>>
>>>>>>>>>>> $query = mysql_query("SELECT * FROM table WHERE id=107;") or
>>>>>>>>>>> die(mysql_error()); // make sure to use double quotes
>>>>>>>>>>> var_dump(mysql_error(), mysql_num_rows());
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> PHP Database Mailing List (http://www.php.net/)
>>>>>>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>>>>>>
>>>>>>>>
>>>>>>
>>>>>>
>>>>
>>>>
>>
>>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
