SQL PHP HTML ASP JavaScript articles and free scripts to download

PHP MySQL Functions to list table names in a databases

We can display a list of tables present in a database by using mysql_list_tables() function. Connection has to be established before call of this function. The result pointer returned by this function is used by mysql_tablename() function to display the name of the tables.

Related Tutorial
• Printing Error message • Posting error message to an email address • PHP MySQL data display

<?
$list = mysql_list_tables ("sql_tutorial");
$i = 0;
while ($i < mysql_num_rows ($list)) {
$tb_names[$i] = mysql_tablename ($list, $i);
echo $tb_names[$i] . "<BR>";
$i++;
}
?>

Post Comment This is for short comments only. Use the forum for more discussions.
Name
Email	( not to be displayed)Privacy Policy
1+2=	This is to prevent automatic submission by spammers. Please enter the result of the sum as asked



Join Our Email List Email:

For Email Newsletters you can trust

Join our FREE Email Mailing List

SQL Tutorial List

mysql_affected_rows mysql_auto_increment mysql_close mysql_connect mysql_create_db mysql_db_name mysql_errno mysql_error mysql_fetch_field mysql_fetch_lengths mysql_fetch_row mysql_field_flags mysql_field_len mysql_field_name mysql_field_type mysql_insert_id mysql_list_dbs mysql_list_tables mysql_num_fields mysql_num_rows mysql_pconnect mysql_query mysql_select_db mysql_tablename

mysql_change_user mysql_data_seek mysql_db_query mysql_drop_db mysql_fetch_array mysql_fetch_assoc mysql_field_seek mysql_field_table mysql_free_result mysql_list_fields mysql_result

SQL site Map

PHP MySQL Functions to list table names in a databases

<? $list = mysql_list_tables ("sql_tutorial"); $i = 0; while ($i < mysql_num_rows ($list)) { $tb_names[$i] = mysql_tablename ($list, $i); echo $tb_names[$i] . "<BR>"; $i++; } ?>

<?
$list = mysql_list_tables ("sql_tutorial");
$i = 0;
while ($i < mysql_num_rows ($list)) {
$tb_names[$i] = mysql_tablename ($list, $i);
echo $tb_names[$i] . "<BR>";
$i++;
}
?>