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]

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

Amen, brother :P

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