heu oui effectivement :oops:

Merci tof73

fetch et pas fecth

	$id_adh = $dataa['id_adh'];

				
				$sqla = $db->prepare("SELECT a.id_adh
				FROM flatforswap_adherent AS a
				LEFT OUTER JOIN flatforswap_logement AS l ON l.id_adh = a.id_adh
				LEFT OUTER JOIN flatforswap_photo AS p ON p.id_log = l.id_log
				WHERE valide = ?
				GROUP BY a.id_adh
				HAVING COUNT(*) > 1 
				ORDER BY RAND()
				LIMIT 5");

$sqla->execute(array('2'));

$i = 1;


while($dataa = $sqla->fecth()){

	$id_adh = $dataa['id_adh'];
	
		// requête pour déterminer la localité de l'adh

try
	{
		$db = new PDO('mysql:dbname=xxxxx;host=localhost', 'yyyyyyy', 'zzzzzzz', array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));
	}
	catch (Exception $e)
	{
        die('Erreur : ' . $e->getMessage());
	}
	$db->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true); 

Bonjour,

je tente de convertir mes requêtes et forcément, il y a du grabuge.

Voici ma première erreur :

[code]
Fatal error: Call to undefined method PDOStatement::fecth()
[/code]

La ligne incriminée est la suivante

[php]
$id_adh = $dataa['id_adh'];
[/php]

Voici le code en amont :

[php]

$sqla = $db->prepare("SELECT a.id_adh
FROM flatforswap_adherent AS a
LEFT OUTER JOIN flatforswap_logement AS l ON l.id_adh = a.id_adh
LEFT OUTER JOIN flatforswap_photo AS p ON p.id_log = l.id_log
WHERE valide = ?
GROUP BY a.id_adh
HAVING COUNT(*) > 1
ORDER BY RAND()
LIMIT 5");

$sqla->execute(array('2'));

$i = 1;


while($dataa = $sqla->fecth()){

$id_adh = $dataa['id_adh'];

// requête pour déterminer la localité de l'adh
[/php]

ma connexion à la base de données se fait de cette façon

[php]
try
{
$db = new PDO('mysql:dbname=xxxxx;host=localhost', 'yyyyyyy', 'zzzzzzz', array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));
}
catch (Exception $e)
{
die('Erreur : ' . $e->getMessage());
}
$db->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true);
[/php]