Did you change $var=108; into
$var=mysql_real_escape_string($_GET['deleteid'])? :
if (isset($_GET['deleteid'])){
$var=mysql_real_escape_string($_GET['deleteid']);
$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:57 PM, David DURIEUX <[EMAIL PROTECTED]> wrote:
> 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 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" <[EMAIL PROTECTED]> a écrit:
>
>>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
>>>>>>>>>
>>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>
>>>>>
>>>
>>>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
