[SOLVED] Variable Variables

[peeaitchpee]

I'm having an issue grabbing the value of a variable, it's asyntax issue and i'm drawing a blank

 

$which = "nav_order";

// nav_order is the column name in a mysql db

 

$sql = "SELECT `id`, `$which` FROM `nav` WHERE `$which` <= '$order' ORDER BY `$which` DESC LIMIT 0, 2";

$result = mysql_query($sql, $connection) or die ("Couldn't execute query.");

$row = mysql_fetch_array($result);

 

// this works fine

 

$this_order = $row['$which'];

 

This is the issue. I cannot get the value of the 'nav_order' column.

 

I thought it was $this_order = $row['{$}which'];, but this is not working, nor is $this_order = $row['$$which'];

 

Thanks in advance

 

[Alex]

$this_order = $row[$which];

 

Anything inside of single quotes will be evaluated as a string. So technically what you had was saying $row['$which'] Actually the string '$which' and not the value of $which.

[peeaitchpee]

wow. only took a few seconds to embarass me. That's the one thing I didnt bother trying. Thanks!