[SOLVED] Grab column names and values

[therealwesfoster]

I'm wanting to pull each column from 1 row and be able to list the column name and value on a page for editing.

 

So if I have a table called "users", and the columns:

id - name - email - pass

 

I want to be able to run a loop that will echo:

id > 1

name > Wes

email > bla@sl.com

pass > passwwoord

 

Make sense? Thanks!

[fenway]

"For editing" is a php issue... does the mysql query pull the desired rows?

[therealwesfoster]

Not needing the editing part, I can do that. I just need help on the query and how to loop it all. A simple example would work

 

Wes

[PFMaBiSmAd]

There are at least two mysql_field_xxxxxx functions listed in the php manual that will give you field (column) names.

[therealwesfoster]

There are at least two mysql_field_xxxxxx functions listed in the php manual that will give you field (column) names.

 

Thanks. Yeah, I just need an example on using them.

 

Wes

[PFMaBiSmAd]

There is an even easier way, when you fetch a row (mysql_fetch_assoc), the keys in the resulting array will be the column names.

 

$row = mysql_fetch_assoc($result);
foreach($row as $key => $value) {
    echo "$key > $value<br />";
}

[therealwesfoster]

There is an even easier way, when you fetch a row (mysql_fetch_assoc), the keys in the resulting array will be the column names.

 

$row = mysql_fetch_assoc($result);
foreach($row as $key => $value) {
    echo "$key > $value<br />";
}

 

That's perfect bro. So simple too.

 

Wes