clues for a clueless guy

[Dormilich]

Hi,

currently I'm stuck on finding the error of one of my functions. I try to read data out of MySQL using PDO. the SQL string is loaded as Prepared Statement (PDO->prepare()) and shall be executed using PDOStatement->execute().

I already know:
- there's no PDOException thrown
- there's no Error message
- the execute method returns false
- the parameters are correctly passed
(- all fields exist in the DB, they are either string types or int)

anyone an idea where to look or how to get more details about the error?

if I try it manually, it works…

            SELECT
                `comment`,
                `date`,
                `email`,
                `homepage`,
                `icq`,
                `id`,
                `ip`,
                `name`,
                `text`,
                `time`
            FROM
                `myphpgb_entries`
            WHERE
                `status` = ?
            ORDER BY
                `id` DESC
            LIMIT
                ?,?

[Dormilich]

it turned out, the last parameter (which was fetched from DB) had the wrong type. typecasting to int solved it.

…what a pain with those types

[Markus]

@Dormilich
Amen, brother :P

It's strange that PDO didn't return an error..