just need field name (mysql_num_fields)

[qadeer_ahmad]

Hi,
I am working with "mysql_num_fields" its working ok and i got name
i am using this query

$query = "select * from $TablesNames";
$sql_tables=mysql_query($query) or die(mysql_error());
while ($j <  mysql_num_fields($sql_tables)) 
{								   $fields_name = mysql_fetch_field($sql_tables, $j);
print $fields_name->name ."<br>";
}

this working nice on local and i got name but on net i have more than one table and a lot of data in these tables i don't need data i need only name when this query run take a lot of time and give no result because time is over
Note" no error message" but incomplete page out put show here

If i remove data from tables then it work nice

I need only name so is thier any query which fetch only fields name then my problem is over.

Thanks

[laserlight]

You could try a:

SELECT * FROM $TablesNames LIMIT 1;

[qadeer_ahmad]

A lot of thanks
Problem is ended