All pastes #630429 Raw Edit

Mine

public text v1 · immutable
·published 2007-07-23 05:26 UTC
rendered paste body
private function my_polls() {
        $polls = $this->db->prepare("SELECT poll_title, poll_id FROM polls WHERE user = :user_id ORDER BY poll_id");
        $polls->bindParam(":user_id", $this->user);
        $polls->execute();
        $poll_wall_items = "";
        $count = 0;
                while($row = $polls->fetch()) {
                $answers = "";
                        $this->template->assign("poll_title", $row->poll_title);
                        $poll_answers = $this->db->prepare("SELECT poll_option FROM poll_answers WHERE poll_id = :poll_id");
                        $poll_answers->bindParam(":poll_id", $row->poll_id);
                        $poll_answers->execute();
                        while($arow = $poll_answers->fetch()) {
                                $answers .= "<tr><td> $arow->poll_option </td></tr>";
                        }
                        $this->template->assign("poll_options", $answers);
                        $count ++;
                        $poll_wall_items .= $this->template->fetch("api_templates/poll_wall_item.php");
                }
                if($count > 0) {
                        $this->template->assign("poll_wall_items", $poll_wall_items);
                        return $this->template->fetch("api_templates/poll_wall.php");
                }
        return $this->template->fetch("api_templates/empty_pollbox.php");
        }