[Resolved] 2 dimensional array in a SQL statement

[kap]

Hi,

I created a two-dimensional array ($pList) which is used in a for loop indexed by $i and has a second index pid0.

      

$xxx = $pList[$i][['pid0']; 
echo $xxx; //returns the correct result of 1

for( $i = 0; $i < count($pList); $i ) {
   $query = "SELECT * FROM TPeople WHERE id = $pList[$i]['pid0']"; 
}
echo $query; //returns the result SELECT * FROM TPeople WHERE id = Array['pid0']

Why is the two dimensional array item not returning the correct value in the where clause of the sql statement

Thanks in advance for any help provided

kap

[Weedpacket]

Originally posted by kap
Why is the two dimensional array item not returning the correct value in the where clause of the sql statement

Because the variable name is a bit too complicated

http://www.php.net/manual/en/language.types.string.php#language.types.string.parsing.complex

   $query = "SELECT * FROM TPeople WHERE id = ".$pList[$i]['pid0'];