[RESOLVED] is the name of the column sent as part of the query results ?

[steamPunk]

Hi

what i mean is how do i do this

	$sql = "SELECT * FROM items LEFT JOIN ext ON ext.id=items.id WHERE items.p_id='0'";
	$res = mysql_query($sql);
 	$num_entries=mysql_num_rows($res);
	while($row = mysql_fetch_array($res)) {	
		$col = $row[ColName];
		echo "<br /><input type=\"text\" name=\"".$col."\" value=\"".$row[$col]."\" />";
	}

where $row[ColName] is the name of the column in question - obviously this doesn't work here - is there a way of doing it like this ?

thanks

[NogDog]

The column names will be used as array keys for the $row array.

echo '<input type="text" name="ColName" value="' . $row['colName'] . '" />';

[dagon]

while($row = mysql_fetch_assoc($res)){
  $array[] = $row; }

foreach($array as $key =>$var){
echo "<br /><input type=\"text\" name=\"".$key."\" value=\"".$var."\" />"; 
}

[steamPunk]

that's excellent !!

I was worried i would have to use SHOW to get a list of column names into an array and then loop through that array for each result

this is much better - thank you both 🙂

[steamPunk]

in fact i still have a tiny problem

when i print_r() the $var :

	$sql = "SELECT * FROM items LEFT JOIN ext ON ext.id=items.id WHERE items.id='2'";
	$res = mysql_query($sql);	
	while($row = mysql_fetch_assoc($res)){
  	$fields[] = $row; 
	}
	foreach($fields as $key =>$var){
		print_r($var);
		echo "<br /><input type=\"text\" name=\"".$key."\" value=\"".$var."\" />";
	} 

i get this

Array ( [id] => 2 [p_id] => 0 [rank] => 2 [title] => item 2 [online] => 1 [type] => page [ext_id] => 2 [adresse] => adresse 2 )

because $var is an array - curses !!

whereas i only need the [adresse] => adresse 2 field name and value

how can i change the foreach so that it will do this ?

thanks

[Weedpacket]

$sql = "SELECT adresse FROM items LEFT JOIN ext ON ext.id=items.id WHERE items.id='2'"; 

        echo "<br /><input type=\"text\" name=\"".$key."\" value=\"".$var['adresse']."\" />";