how return a field name with the value in a mysql query?

--------------------------------------------------------------------------------

hi,
i need get the name of the field by a query
for example

if a do this:

$res = mysql_query( "select * from total )
$v1=mysql_fetch_row_name($res);
while($v1=mysql_fetch_row($res)) {

echo $v1[0]; // return the value of field number 0

}

but i need to know also this:


echo "the field name xxx have this record ". $v1[0];

in vb we have the objects that return the name and the value and all information of the field but how can i see this in php?
thanks a lot for your help

 

Lol ur code is totally wrong...

I'll give an example with my favourite table "users"

<?php
$select = mysql_query("SELECT * FROM users");
while($row = mysql_fetch_array($select)) {
 echo $row['username']; //This will display the username selected from the query
}
?>

PHP:

You can change 'username' to ip, last_login, etc.

 

This function may help you.

http://my.php.net/mysql_field_name