Problem with mysqli stmt and multi queris.

[Uzytkownik]

I've some function:
function show($id) {
$title = $text = $date = $nick = NULL;
$stmt = $this->base->stmt_init();
$stmt->prepare("SELEC T title,text,date time,nick FROM posts LEFT JOIN authors ON authors.id=post s.id WHERE posts.id=?");
$stmt->bind_param('i' , $id);
$stmt->bind_result($t itle, $text, $date, $nick);
$stmt->execute();
$stmt->fetch();
return array('title'=> $title, 'text'=>$text, 'date'=>$date, 'author'=>$nick , 'tags' => $this->tags->get($id));
}
Function use in last line:
function get($id) {
$tag = '';
$stmt = $this->base->stmt_init();
$stmt->prepare("SELEC T tags.name FROM tags LEFT JOIN tags_names ON tags_names.id = tags.tag_id WHERE tags.post_id=?" );
$stmt->bind_param('i' , $id);
$stmt->bind_result($t ag);
$stmt->execute();
$names = array();
while($stmt->fetch()) {
array_push($nam es, $tag);
}
return $id;
}
It's shows:

Warning: mysqli_stmt::bi nd_param() [function.bind-param]: Number of variables doesn't match number of parameters in prepared statement in /home/uzytkownik/workspace/blog/classes/tags.php on line 64

Warning: mysqli_stmt::bi nd_result() [function.bind-result]: Number of bind variables doesn't match number of fields in prepared statement. in /home/uzytkownik/workspace/blog/classes/tags.php on line 65
array(5) { ["title"]=> string(4) "Test" ["text"]=> string(4) "Test"
["date"]=> string(19) "2005-11-22 08:09:33" ["author"]=> string(10)
"uzytkownik " ["tags"]=> int(1) }

I've experimented with $stmt->: close, free/store_result, reset ect.

What's wrong?

Regards

[Uzytkownik]

On Fri, 25 Nov 2005 20:36:49 +0100, Uzytkownik wrote:

I've some function:
function show($id) {
$title = $text = $date = $nick = NULL;
$stmt = $this->base->stmt_init();
$stmt->prepare("SELEC T title,text,date time,nick FROM posts LEFT JOIN authors ON authors.id=post s.id WHERE posts.id=?");
$stmt->bind_param('i' , $id);
$stmt->bind_result($t itle, $text, $date, $nick);
$stmt->execute();
$stmt->fetch();
return array('title'=> $title, 'text'=>$text, 'date'=>$date, 'author'=>$nick , 'tags' => $this->tags->get($id));
}
Function use in last line:
function get($id) {
$tag = '';
$stmt = $this->base->stmt_init();
$stmt->prepare("SELEC T tags.name FROM tags LEFT JOIN tags_names ON tags_names.id = tags.tag_id WHERE tags.post_id=?" );
$stmt->bind_param('i' , $id);
$stmt->bind_result($t ag);
$stmt->execute();
$names = array();
while($stmt->fetch()) {
array_push($nam es, $tag);
}
return $id;
}
It's shows:

Warning: mysqli_stmt::bi nd_param() [function.bind-param]: Number of variables doesn't match number of parameters in prepared statement in /home/uzytkownik/workspace/blog/classes/tags.php on line 64

Warning: mysqli_stmt::bi nd_result() [function.bind-result]: Number of bind variables doesn't match number of fields in prepared statement. in /home/uzytkownik/workspace/blog/classes/tags.php on line 65
array(5) { ["title"]=> string(4) "Test" ["text"]=> string(4) "Test"
["date"]=> string(19) "2005-11-22 08:09:33" ["author"]=> string(10)
"uzytkownik " ["tags"]=> int(1) }

I've experimented with $stmt->: close, free/store_result, reset ect.

What's wrong?

Regards

Resolved after rewrite the code.

Regards