[Resolved] obtain table fields?

slevytam

hi,

i am looking to use only a table name to output something like this. basically just a output of the table contents but without knowing the field names...

TABLENAME
field1name = field1contents
field2name = field2contents
.
.
.

could someone help me do this

thanks,

TheDefender

/* Put in your connection and DB selection code here */

// Query the table
$qry = mysql_query("SELECT * FROM table");
$getqry = mysql_fetch_array($qry);

// Output the field names and value
foreach($getqry AS $k => $v){
echo $k." = ".$v."<br />";
}

Of course, this will output the field names fine, but only the last row of data that is pulled out. If your table has more than one row of data, and you want that, then you need to run it through a while loop.

slevytam

Thanks for your reply...

For some reason the for loop is outputing two lines...

ie.
5 = 1920
year = 1920

any idea why this might be?

thanks again,

tomhath

Post the code that's producing the incorrect result; something else is wrong.

LordShryku

[man]mysql_fetch_array[/man]

The optional second argument result_type in mysql_fetch_array() is a constant and can take the following values: MYSQL_ASSOC, MYSQL_NUM, and MYSQL_BOTH. This feature was added in PHP 3.0.7. MYSQL_BOTH is the default for this argument.

Put a second argument of MYSQL_ASSOC in your mysql_fetch_array argument and it should only return the associated field name => value.

slevytam

Perfect!

MYSQL_ASSOC worked!

Thanks everyone,

TheDefender

My apologies for that oversight...