Database tables

[sedric1]

is it possible to connect to my database (mysql) and output the table names and fields of the database automatically (without hardcoding the names)?

[LordShryku]

yes

[sedric1]

well- in what way should i be looking at this? is there a simple sql command that does this or is there a particular query i have to use?

[LordShryku]

Check the manual under [man]mysql[/man]. There's functions to handle this.

[sedric1]

cool thanks- i basically used the example, but it is giving me an internal server error (500).

<? $dbname = 'thedatabase';
mysql_connect('host', 'user', 'pass'); //replaced with actual info
$result = mysql_list_tables($dbname);
if (!$result)
{ echo 'MySQL Error: ' . mysql_error();
exit;
}
while ($row = mysql_fetch_row($result))
{
echo "Table: $row[0]\n";
}
mysql_free_result($result); ?>

any ideas or suggestions?

[LordShryku]

Try it as a SQL statement. I just tested this and it works for me. I guess mysql_list_tables is depreciated, though that shouldn't be the problem.

<?php
$db   = 'mysql';
$conn = mysql_connect('host', 'user', 'pass');
        mysql_select_db($db, $conn);

$sql  = 'SHOW TABLES FROM '.$db;
$res  = mysql_query($sql) or die(mysql_error());
if(mysql_num_rows($res) > 0) {
   while($row = mysql_fetch_row($res)) {
      echo $row[0].'<br />';
   }
}
else {
   echo 'No tables found in '.$db;
}
mysql_close($conn);
?>