[RESOLVED] MySQL "SHOW TABLES" question

[aaronfenker]

I have a database with multiple tables. I want to be able to list all the tables which the database contains, which I have figured out.

  $sql = "SHOW TABLES";

  $result = mysql_query($sql);
  $rows = mysql_num_rows($result);

  while($list = mysql_fetch_array($result)) {
    print("$list[0]<br />");
  }

The problem is that I want to be able to store each of the table names into different variables. I'm stuck because all of the table names are stored under $list[0]. Any suggestions?

[devinemke]

why don't you simply store the table names in an array?

$result = mysql_query('SHOW TABLES') or exit(mysql_error());
while ($row = mysql_fetch_row($result))
{
	$tables[] = $row[0];
}

echo '<pre>'; print_r($tables);  echo '</pre>';

[aaronfenker]

Yeah, I thought about that later. I need to stop programming when I'm exhausted.

[bradgrafelman]

Don't forget to mark this thread resolved (if it is).

[aaronfenker]

Thanks for the help.