Forum d'entraide PHPFrance

<?php
$db = mysql_connect('sql.free.fr', 'xxx', 'xxx'); // 1
mysql_select_db('yuu_sw',$db); // 2
$req = mysql_query("SELECT ban_id FROM a_ban WHERE user_id='$id3'"); // 3
$res = mysql_num_rows($req);
$nbre_ban = $res; // 4

echo"Vous avez $nbre_ban bannieres actives"; // 5

$sql = mysql_query("SELECT ban_emp FROM a_ban WHERE user_id='$id3'");
$ret = mysql_fetch_assoc($sql);
while($aff = mysql_fetch_array($ret))
{
'<p><div align=/"center"/><img src=/"'.$aff['ban_emp'].'"/></div></p>';
}

mysql_close($db); // 6
?>

Vous avez 1 bannieres actives
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/sdc/0/8/yuu.sw/echange/membres/ban.php on line 121

mysql_fetch_assoc() revient à appeler la fonction mysql_fetch_array() avec MYSQL_ASSOC en tant que second paramètre.

$sql = mysql_query("SELECT ban_emp FROM a_ban WHERE user_id='$id3'");
$ret = mysql_fetch_assoc($sql);
while($aff = mysql_fetch_array($ret))
{

$sql = mysql_query("SELECT ban_emp FROM a_ban WHERE user_id='$id3'");
while($aff = mysql_fetch_assoc($sql))
{