SQL syntax

[Chris_Evans]

Hi, in a while loop using sql I found a small problem.

$x is a number - starting at 1

$x = 1; then in the loop I put this

	echo '<label><input type="radio" name="poll" value="poll">';
	echo $poll['answer'.$x];
	echo '</label><br>';

Trouble is, it doesn't add the number to the end of the sql retrieve so it cant find a field called answer because they're called answer1 answer2 etc.

Thanks,

Chris

[kevinsequeira]

echo '<label><input type="radio" name="poll" value="poll">';

$temp_name = "answer".$x;
$temp_value = ${temp_name};
echo $poll['$temp_value'];

echo '</label><br>';

reg
kevin

[Chris_Evans]

Ah! Quite simple... I wasn't thinking the logical way around, as usual lol. Thanks Kevin! 🙂