PHP5: problem with mysqli_prepare/mysqli_bind_param

From: Date: Fri, 20 Aug 2004 19:14:25 +0000
Subject: PHP5: problem with mysqli_prepare/mysqli_bind_param
Groups: php.general 
Request: Send a blank email to php-general+get-194363@lists.php.net to get a copy of this message
[snip] 172: $q = $this->DB["cms"]->prepare("SELECT t.Extension FROM Site_Mime as m,Type as t WHERE m.SNr=? && m.TNr=t.Nr"); 173: $q->bind_param("i",$this->Site["Nr"]); 174: $q->execute(); 175: $q->store_result(); [/snip] I've got a very serious problem in big class, but these two lines are probably the origin if my problem: $this->DB["CMS"] is a valid mysqli_connection $this->Site["Nr"] is a number - in the current test-case it is 3 I've also checked the tables. There is a row with SNr=3 and TNr=2 in Site_Mime, and there is a row in the table Type with Nr=2. So I would expect to get at least one row as a result of this query, but $q->num_rows has only the value "" Then I tried simply to add ' on both sides of the ? but it got only ('?' instead of ?)weird: Warning: mysqli_stmt::bind_param() [function.bind-param.html]: Number of variables doesn't match number of parameters in prepared statement in C:\Programme\Apache Group\Apache2\htdocs\cms\lib\cms\site.class.php on line 173 has anyone an idea of what is wrong there? is it possible that this is a bug? thx for helping ;)

« previous php.general (#194363) next »