Re: Probleme with MySQL queries
| From: | David DURIEUX | Date: | Wed, 03 Sep 2008 10:21:00 +0000 |
| Subject: | Re: Probleme with MySQL queries | ||
| References: | 1 2 3 4 5 6 7 8 9 10 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-45318@lists.php.net to get a copy of this message | ||
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());
>