variable as row?

[tragikx]

if i have a database column called "blue", how would i make the following work...

$color = 'blue';

while ($row = mysql_fetch_assoc($result)) { 
  echo $row[$color].'<br />'; 
}

$row[$color] doesnt work...and for what i'm trying to do i cant use $row['blue']...i'm guessing there is a way to do this plz help! =)

[Drakla]

That should work, can we see an example of the query pulling out the data?

[tragikx]

must have done something funky..dont know what i did to fix it but i've been working on this project quite a bit today and something i did makes it work like intended (based on your reply)

thanks for the reply 😃