My bad, it should have the query handle as a parameter of course:
$var=107;$query = mysql_query("SELECT * FROM table WHERE id={$var};") ordie(mysql_error()); // make sure to use double quotesvar_dump(mysql_error(), mysql_num_rows($query));
$var=mysql_real_escape_string("107");$query = mysql_query("SELECT * FROM table WHERE id={$var};") ordie(mysql_error()); // make sure to use double quotesvar_dump(mysql_error(), mysql_num_rows($query));
$query = mysql_query("SELECT * FROM table WHERE id=107;") ordie(mysql_error()); // make sure to use double quotesvar_dump(mysql_error(), mysql_num_rows($query));
On Wed, Sep 3, 2008 at 12:21 PM, David DURIEUX <d.durieux@xxxxxxxxxxxxx> 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>>
