[Resolved] [Resolved] show databases php function

[wacook]

Is there a way to show available mysql databases with php?

Is there a way to show available mysql tables with php?

Is there a way to show available mysql column names with php?

I did find the SHOW DATABASE mysql command but it looks like this is a command line option not a php function.

[devinemke]

Is there a way to show available mysql databases with php?

$result = mysql_query('SHOW DATABASES');

Is there a way to show available mysql tables with php?

$result = mysql_query('SHOW TABLES');

Is there a way to show available mysql column names with php?

$result = mysql_query('DESCRIBE tablename');

I did find the SHOW DATABASE mysql command but it looks like this is a command line option not a php function.

...and since PHP can easily be used to throw commands to mySQL this shouldn't be a problem.

[LordShryku]

Also, with a quick look through the manual, you could have found [man]mysql_list_dbs[/man], [man]mysql_list_tables[/man], and [man]mysql_list_fields[/man].