Re: Probleme with MySQL queries

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@siprossii.com 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@onshore.com> 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@siprossii.com >> 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@gmail.com> 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()); >>> >>> >> >> >> >