Problem displaying fields name and value.

Shawn_Jetton

I'm new to php and been searching for an answer before I posted but to be truthful I'm not sure what to search for. Below is my code that I have. My search will bring back only one recordset but I want to display the name of the field and it's value. Maybe I'm going about this all wrong.

This will display the name but I can't figure out how to display the value. 😕

$viewid = $_GET["ID"];
$sql = "SELECT * FROM $table_name WHERE ID = $viewid";
$result = mysql_query($sql, $db);
while(($field = mysql_fetch_field($result)))
{
    echo $field->name."<BR>\n";
}

YappyDog

You need to use the mysql_fetch_row fuction instead of the mysql_fetch_field function. There are lots of examples in the manual.

http://us3.php.net/manual/en/function.mysql-fetch-row.php

Shawn_Jetton

Thanks YappyDog.. I took a different look at it and ended up with what you suggested..

$viewid = $_GET["ID"];
$sql = "SELECT * FROM $table_name WHERE ID = $viewid";
$result = mysql_query($sql, $db);
$fieldcount = mysql_num_fields($result);
$fieldvalue = mysql_fetch_row($result);
$i=0;
while($i<$fieldcount)
{
	echo mysql_field_name($result,$i)." = ".$fieldvalue[$i]."<BR>";
	$i++;
}