Re: Probleme with MySQL queries
| From: | Evert Lammerts | Date: | Wed, 03 Sep 2008 10:24:27 +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-45320@lists.php.net to get a copy of this message | ||
My bad, it should have the query handle as a parameter of course:
$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($query));
$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));
$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($query));
On Wed, Sep 3, 2008 at 12:21 PM, David DURIEUX <d.durieux@siprossii.com> 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());
>>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>