devFAIL

Found this bit in a model class of my own.

static public function active_product($product_type, $role_id) {
	$q = 'SELECT COUNT(*)
                FROM product
                WHERE
                    visible = 1 AND
                    (deleted = 0 OR archived = 0) AND
                    postedby_role_id = ? AND
                    product_type = ?';

        $sth = $dbh->prepare($q);
        $sth->execute($role_id, $product_type);

        $product_count = 0;
        while(list($count) = $sth->fetchrow_array()) {
            $product_count += $count;
        }

        return $product_count;
}

WTF was I smoking?

Posted on Monday, December 29th, 2008 at 8:41 pm in FAIL | rss feed for comments| Leave a response, or trackback