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?

i believe answers below have solved your problem , if yes than mark one of them as answered — Aman Virk
– Aman Virk, Commented Feb 26, 2012 at 18:29

Mark Baker · Accepted Answer · 2012-02-26 18:12:43Z

2

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>"; 
}

answered Feb 26, 2012 at 18:12

Mark Baker

213k34 gold badges354 silver badges390 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ThomasH Over a year ago

Thanks a lot! Ed's solution below works too, but Mark was faster on the draw. For anybody struggling: my error was missing the final .

Ed Heal · Accepted Answer · 2012-02-26 18:26:39Z

1

Perhaps you need

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

edited Feb 26, 2012 at 18:26

answered Feb 26, 2012 at 18:12

Ed Heal

60.3k18 gold badges90 silver badges137 bronze badges

1 Comment

Liyali Over a year ago

Fix your first variable name ;) You missed a "_" sign.

wormhit · Accepted Answer · 2012-02-26 18:41:28Z

0

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']}";

answered Feb 26, 2012 at 18:41

wormhit

3,8672 gold badges41 silver badges48 bronze badges

Collectives™ on Stack Overflow

Using variable to loop through rows in PHP

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related