hi,

   Is there a way by which I can use PHP to retrieve MySQL
TABLE names ???
thanks and regards.

__________________
site lead ,apartment27 studios.

Sure, you can. The function to help you is : mysql_list_tables

Here is the sample code taken from PHP manual.

<?php
$dbname = 'mysql_dbname';

if (!mysql_connect('mysql_host', 'mysql_user', 'mysql_password')) {
    echo 'Could not connect to mysql';
    exit;
}

$result = mysql_list_tables($dbname);

if (!$result) {
    echo "DB Error, could not list tables\n";
    echo 'MySQL Error: ' . mysql_error();
    exit;
}

while ($row = mysql_fetch_row($result)) {
    echo "Table: $row[0]\n";
}

mysql_free_result($result);
?>

Hi,

   Thanks a LOT. that resolved the table names issue.
thanks again.