variable undefined

[OniLink]

Can someone please tell me why this code returns an error saying the variable $rounds is undefined (returns the error on the last line where the $sql variable is):

// code for retrieving users choices
$currentRound = $POST['currentRound'];
$roundMax = $currentRound-1;
for ($i=1; $i<$roundMax; $i++) {
if ($i != $currentRound) {
$rounds .= 'r'.$i.' AND ';
} else {
$rounds .= 'r'.$i;
}
}
$sql = 'SELECT '.$rounds.' FROM users WHERE user_id = '.$POST['user_id'];

Or is there a better way of doing this? Thanks for any help,
~Oni.

[thorpe]

Not sure why it would be undefined, but there is no way that is going to make a valid query.

What is this line doing?

$rounds .= 'r'.$i.' AND ';

SELECT r1 AND r2 AND r3 AND r4 FROM tbl;

Is never going to be a valid query. Look up how and where to use AND in the sql manual.

[OniLink]

Thanks. Then how would I go about getting the values from r1, r2, r3, etc.?

edit
I found a way. Thanks anyway.