php variable inside a variable in a while query

Question

I have a variable:

$category =  3;

$data = MY SQL QUERY....

while ($data2 = mysql_fetch_array( $data)) 
    {   echo $data2['$category'] ; }

I want to get the sql value of echo $data2['3']; by using the vairable $category ...

is there a way to do this ?

Leo · Accepted Answer · 2014-12-29 21:28:08Z

2

Your code looks correct but you have to remove the single quotes

{   echo $data2['$category'] ; }

should be changed to

{   echo $data2[$category] ; }

answered Dec 29, 2014 at 21:28

Leo

1,51524 silver badges44 bronze badges

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

1 Answer 1