Select all field names

[run_GMoney]

Is there a way to perform a SELECT that would grab only the field names from a TABLE. In my head, I'm thinking I could create an array with mysql_fetch_array and then possibly grab all of the array keys from that? Would that work, first off, and second is there a better solution?

[stolzyboy]

try this

<?
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 table") or die("Query failed");
$i = 0;
while ($i < mysql_num_fields($result)) {
    $meta = mysql_fetch_field($result);
    if (!$meta) {
        echo "No information available<br>";
    }
    echo "<b>Field Name:</b> $meta->name<br>";
    $i++;
}
mysql_free_result($result);
?>

[run_GMoney]

That looks pretty handy. I've never seen a couple of those functions. I'll put that to use. Thanks, stolz

[run_GMoney]

Quick question so I understand fully what's happening: What is this part doing exactly?

$meta->name<br>";

I think it has something to do with arrays but I'm not positive.

[stolzyboy]

its just another way of doing a regular while fetch array loop to get something like $row['fieldname'];

its more of a PERL like syntax (shudder)

[run_GMoney]

Fair enough, thanks again.