how return a field name with the value in a mysql query?
Posted: Sun Feb 15, 2009 10:59 am
--------------------------------------------------------------------------------
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
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