Using fetch array in foreach loop PHP

Question

So basicly this is my code:

echo "<SELECT>";
foreach($arr_res as $op) {
   $q3 = mysql_query(mysql_fetch_array("SELECT SL_TIME FROM SLOTS WHERE SL_ID='$op'"));
   echo "<OPTION value=".$op.">".$q3."</OPTION>";
}
echo "</SELECT>";

$arr_res is the resulting array of an array_diff. It has only numerical values which are the SL_ID from my timeslots.. I want to show SL_TIME but the result I get is the $q3 producing empty result.. Why isn't this working?

Boelensman1 · Accepted Answer · 2012-10-07 15:48:41Z

1

You don't query mysql_fetch_array. Mysql_query gives an result on wich you use mysql_fetch_array. So the correct code would be:

echo "<SELECT>";
foreach($arr_res as $op){
$result = mysql_query("SELECT SL_TIME FROM SLOTS WHERE SL_ID='$op'");
$q3=mysql_fetch_array($result);
echo "<OPTION value=".$op.">".$q3."</OPTION>";
}
echo "</SELECT>";

However, $q3 will be an array, which is probably not what you want. In addition it would be a lot better if use an abstraction such as PDO (http://www.php.net/manual/en/class.pdo.php). This will maximize performance and increase the security.

answered Oct 7, 2012 at 15:48

Boelensman1

3142 silver badges15 bronze badges

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

1 Comment

Jake Rowsell Over a year ago

Allthough copy and pasting your solution didn't directly work with a few minor adaptations it did fix the problem! Thank you so much! :) (too low to upvote sorry)

Collectives™ on Stack Overflow

Using fetch array in foreach loop PHP

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related