What does var_dump($_GET) say?
On Wed, Sep 3, 2008 at 12:48 PM, David DURIEUX <[EMAIL PROTECTED]> 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 : [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 12:39:45 +0200
> "Evert Lammerts" <[EMAIL PROTECTED]> a écrit:
>
>>Fixed then?
>>
>>On Wed, Sep 3, 2008 at 12:39 PM, David DURIEUX
>><[EMAIL PROTECTED]> 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 : [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 12:36:43 +0200
>>> "Evert Lammerts" <[EMAIL PROTECTED]> 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
>>>><[EMAIL PROTECTED]> wrote:
>>>>> Bonjour,
>>>>>
>>>>> I have :
>>>>>
>>>>> NULL
>>>>>
>>>>>
>>>>>
>>>>> 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 12:29:44 +0200
>>>>> "Evert Lammerts" <[EMAIL PROTECTED]> 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
>>>>>><[EMAIL PROTECTED]> 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 : [EMAIL PROTECTED]
>>>>>>> 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 <[EMAIL PROTECTED]> 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 : [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 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" <[EMAIL PROTECTED]> 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
>>>>>>>
>>>>>>>
>>>>>
>>>>>
>>>
>>>
>
>
