Проблем със заявка...

[purko]

<?php
define('DB_NAME','ne6to');
define('DB_HOST','localhost');
define('DB_USER','root');
define('DB_PASS','');
define('DB_DSN', sprintf('mysql:host=%s;dbname=%s', DB_HOST, DB_NAME));
function exception_handler($exception) {
	echo "Uncaught exception: " , $exception->getMessage(), "\n";
}
set_exception_handler('exception_handler');
$dbh = new PDO(DB_DSN, DB_USER, DB_PASS);
$sql = "SELECT * FROM customers";
foreach ($dbh->query($sql) as $row){
	$user_id = $row['id'];
	$sql2 = "SELECT sum(amount) FROM sales WHERE id='$user_id'";
	foreach ($dbh->query($sql2) as $row2){
		echo$row2[0]."<br>";
	}
}

?>

Защо ми дава това:

Warning: Invalid argument supplied for foreach() in D:\codes\xampp\htdocs\php\zaqvki\index.php on line 17

Warning: Invalid argument supplied for foreach() in D:\codes\xampp\htdocs\php\zaqvki\index.php on line 17

Warning: Invalid argument supplied for foreach() in D:\codes\xampp\htdocs\php\zaqvki\index.php on line 17

Warning: Invalid argument supplied for foreach() in D:\codes\xampp\htdocs\php\zaqvki\index.php on line 17

Някакви идеи?

 

[Anonymous]

Защото $dbh->query($sql) е презен стринг :?:
Просто си направи една проверка, дали е масив и тогава го прекарвай през foreach()