Name of fields

[ashz]

Hi,

How can I store in an array all the MySQL field names?

Thanks.

[dotbob]

try this...

<?
mysql_connect('somehost','root','pass');
$str_SQL= "SELECT * FROM tblname";
$result = mysql_db_query("dbname", $str_SQL);

$numfields = mysql_num_fields($result);
for($i = 0; $i < $numfields; $i++)
{	
	$str_Fields.=mysql_field_name($result,$i).",";
}
?>

[dotbob]

didn't read the question properly.

to store the fieldnames in an array:

<?
mysql_connect('somehost','root','pass');
$str_SQL= "SELECT * FROM tblname";
$result = mysql_db_query("dbname", $str_SQL);

$numfields = mysql_num_fields($result);
for($i = 0; $i < $numfields; $i++)
{    

    $str_Fields[]=mysql_field_name($result,$i).",";
}
?>

[dotbob]

oh and remove the

.","

at the end

[stolzyboy]

this will work to retreive the fields from a specific table in your database

<?
mysql_connect('localhost', "username", "password") or die("Could not connect to mysql");
mysql_select_db("databasename") or die("Could not connect to database");
$result = mysql_query("select * from tablename") or die("Query failed");
$i = 0;
while ($i < mysql_num_fields($result)) {
    $meta = mysql_fetch_field($result);
    if (!$meta) {
        echo "No information available<br />\n";
    }
    echo "<b>Field Name:</b> $meta->name<br>";
    $i++;
}
mysql_free_result($result);
?>