mysql query for each of the values of an array

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?

If you have 2, 2, 1, your first two echos will be the same — Adam Wenger
– Adam Wenger, Commented Nov 26, 2011 at 19:36
I made it 2,1 and I want to do SELECT puan FROM sorular WHERE ID = 2 SELECT puan FROM sorular WHERE ID = 1 but in a functional way as you understand from my question — user1056307
– user1056307, Commented Nov 26, 2011 at 19:41
What is $aylik? Would it be possible to combine the two queries into one so you do not need to loop twice? — Adam Wenger
– Adam Wenger, Commented Nov 26, 2011 at 19:43
$aylik is a query that takes question id's which user solved from a table in a certain period of time. — user1056307
– user1056307, Commented Nov 26, 2011 at 19:47
Note that the mysql extension is outdated and on its way to deprecation. All new code should use mysqli or PDO, both of which have many advantages, including prepared statements. Instead of interpolating values directly into the statement, you should use a prepared statement, which lets you re-use the query and keeps the value separate. — outis
– outis, Commented Nov 26, 2011 at 22:59

remiheens · Accepted Answer · 2011-11-26 19:46:07Z

4

You have to fetch the result

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

answered Nov 26, 2011 at 19:46

remiheens

3872 silver badges10 bronze badges

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

2 Comments

user1056307 Over a year ago

now the results are 3,4 when I do array_sum($result) it shows me 4 not 7. Can you help me about that also?

remiheens Over a year ago

You have to be careful with the type of your values in this array. This should be int value.

jcorry · Accepted Answer · 2011-11-26 19:47:51Z

1

You have to get the results in some form.

http://php.net/manual/en/function.mysql-query.php

mysql_query returns a resource...not the results of the query. To get the results you have to use one of the mysql_fetch_* functions, in this example we fetch an object with the query results.

http://www.php.net/manual/en/function.mysql-fetch-object.php

Try something like this:

for ($i=0; $i<=$gsayi-1; $i++) {
    $a[] = mysql_result($aylik,$i);
}
foreach ($a as $value) {
    $result = mysql_query("SELECT puan FROM sorular WHERE ID = $value");
    while($row = mysql_fetch_object($result) {
        echo $value . ' = ' . $row->puan . ' | ';
    }
}

answered Nov 26, 2011 at 19:47

jcorry

112 bronze badges

1 Comment

user1056307 Over a year ago

now the results are 3,4. when I do array_sum($result) it shows me 4 not 7. Can you help me about that also?

Collectives™ on Stack Overflow

mysql query for each of the values of an array

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related