mysql查询数组的每个值

Question

for ($i=0; $i<=$gsayi-1; $i++)
  {
    $a[] = mysql_result($aylik,$i);
  }
foreach ($a as $value)
  {
    $m = mysql_query("SELECT puan FROM sorular WHERE ID = $value");
    echo $m; 
  }

a[ ] array is

2,2,1

I am trying to execute a mysql query with each of that values. I am using that values as ID.

I tried foreach loop but it shows me Resource id #7Resource id #7

How can I solve this problem?

Answer 1

You have to fetch the result

$m = mysql_query("SELECT puan FROM sorular WHERE ID = $value");
$result = mysql_fetch_assoc($m);
echo $result['puan'];