Which means you do get results and your select works.
Now try:
$var=107;$query = mysql_query("SELECT * FROM table WHERE id={$var};") ordie(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>>
