php mysqli error

Hello,

I have had an issue for the past week or so that I cannot find a decent
explanation for. I am receiving the following warning when using mysqli
to insert a bunch of records into a database...

*Warning*: mysqli_stmt_bind_param() [function.mysqli-stmt-bind-param
]: Number of variables
doesn't match number of parameters in prepared statement in *c:\program
files\apache group\Apache\htdocs\prepared.php* on line *21

*Now the machine it's failing on is running PHP 5.1.4 with mysqli API
version 5.0.22 but I have used this exact same script (just copied it
over) on another machine running PHP 5.2.1 with mysqli API version
5.0.22 querying the same database and it worked without issue, so it is
not an issue with the code. Is it the PHP version that is causing the
problem? Or where else should I be looking?

Any help would be appreciated as I am really at a loss as to why this
works fine on one machine and not on the other... and unfortunately I
could not find any explanation anywhere else.

Thanks in advance,
Josh

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: php mysqli error

----- Original Message -----
From: "Josh Diakun"
To:
Sent: Monday, April 30, 2007 5:42 PM
Subject: [PHP-DB] php mysqli error


> Hello,
>
> I have had an issue for the past week or so that I cannot find a decent
> explanation for. I am receiving the following warning when using mysqli
> to insert a bunch of records into a database...
>
> *Warning*: mysqli_stmt_bind_param() [function.mysqli-stmt-bind-param
> ]: Number of variables
> doesn't match number of parameters in prepared statement in *c:\program
> files\apache group\Apache\htdocs\prepared.php* on line *21

plzzz help us out
when u said problem.. plz include with the source where the code was problem
occurs. anyway.. i'm not using mysqli and hope other might help u.

i believe u misstype on the variable.. perhaps u should type the source to
find the answer.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: php mysqli error

Josh Diakun wrote:
> Hello,
>
> I have had an issue for the past week or so that I cannot find a decent
> explanation for. I am receiving the following warning when using mysqli
> to insert a bunch of records into a database...
>
> *Warning*: mysqli_stmt_bind_param() [function.mysqli-stmt-bind-param
> ]: Number of variables
> doesn't match number of parameters in prepared statement in *c:\program
> files\apache group\Apache\htdocs\prepared.php* on line *21
>
> *Now the machine it's failing on is running PHP 5.1.4 with mysqli API
> version 5.0.22 but I have used this exact same script (just copied it
> over) on another machine running PHP 5.2.1 with mysqli API version
> 5.0.22 querying the same database and it worked without issue, so it is
> not an issue with the code. Is it the PHP version that is causing the
> problem? Or where else should I be looking?

To check that theory watch your mysql logs - what's getting to the
database? Are you trying to insert exactly the same data on both systems?

--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php