Hey all,

I am trying to make a script where I can query for a column that changes depending on a passed variable. So I have a variable passed called division, lets say it will be a, b, c or d.. I want to get the value in the column division_value1. I initially tried:
PHP Code:
$row mysql_fetch_array($query)
$result $row[$division 'value1'
but it didn't work and I feel it's probably not what I should be trying.. Any suggestions would be appreciated