une requete dans une requete
Bonjour,
voici mon code :
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| $link = mysql_connect("localhost", "root", "")
or die("Impossible de se connecter : " . mysql_error());
unset($result);
$bd = "mabase";
$sql_a = "SHOW TABLES FROM $bd";
$result_a = mysql_query( $sql_a , $link );
while ($row_a = mysql_fetch_array($result_a, MYSQL_NUM)) {
$table = $row_a[0];
echo $table;
$sql_b = "SHOW COLUMNS FROM $table";
$result_b = mysql_query( $sql_b , $link );
while ($row_b = mysql_fetch_array($result_b, MYSQL_NUM)) {
echo $row_b[0];
}
} |
j'obtiens systematiquement le message :
Citation:
mysql_fetch_array() expects parameter 1 to be resource, boolean given in
Une petite idée ?
d'avance merci