Using variable to loop through rows in PHP

Question

Total noob, having trouble using a variable to loop through row. I'd like to print the contents of the column header_en. So I:

Set $lang to en, connect to db and SELECT *

Then:

while($row = mysql_fetch_array( $result )) {
    echo "<h3>Headline is: $row['header_$lang]</h3>";
    echo "<p>Author: $row[author]</p>";
} 

I've been searching for hours, tried concatenating around the $lang variable, all sorts of stuff... no luck. My syntax-fu isn't all that strong yet.

Any pointers?

Answer 1

Try

echo "<h3>Headline is: " . $row['header_'.$lang] . "</h3>";

or even

$headerLanguage = 'header_'.$lang;
while($row = mysql_fetch_array( $result )) { 
    echo "<h3>Headline is: " . $row[$headerLanguage] . "</h3>"; 
    echo "<p>Author: $row[author]</p>"; 
} 

Answer 2

Perhaps you need

echo "<h3>Headline is: ".$row['header_'.$lang]."</h3>"; 
echo "<p>Author: ".$row['author']."</p>"; 

Answer 3

If you use quotes in php you need to know this:

echo 'single quotes are faster, but dont see variables ' . $variable;
echo "double quotes can see them like so: $variable";
echo "to show array in doble quotes use brackets {$array['key']}";