Grabbing array from database, then getting information using each array value

Question

totally stumped in this, basically I'm getting a comma seperated list from a user table, using it as an array and then using each value in the array to fetch data from a different table and output then.

$award_array = array($user_class->awards);
foreach($award_array as $award) {
    $getaward = mysql_query("SELECT `name`, `text`, `image` FROM `awards_av` WHERE `id` = '".$award."'");
    $awardstuff = mysql_fetch_array($getaward);
    echo "<img src='".$awardstuff['image']."' alt='".$awardstuff['name']."' title='".$awardstuff['text']."' />";
}

This is only giving out the first number in the array ($user_class->awards in this case is 1,2,3,4,5,6)

Any help is much appreciated!

Please append the output of var_dump($award_array); to your question. — crush
– crush, Commented Feb 4, 2014 at 19:46
Not sure I follow, if $user_class->awards has comma separated values $award_array would look like this: array(1) { [0]=> string(11) "1,2,3,4,5,6" } — Durandal
– Durandal, Commented Feb 4, 2014 at 19:50

Armin · Accepted Answer · 2014-02-04 20:22:11Z

1

I think I see the problem. You cannot simply take a string of a comma separated list, and throw it inside an array() tag and expect it to automatically convert it to an array. You must use the explode() function to do that.

What you're trying to do:

<?php
$string = 'a,b,c,d,e';
$myarray = array($string);
foreach ($myarray as $k => $v) {
    print $v .'<br />';
}
?>

Except that doesn't work. You need to convert the comma-separated list of values (which is a string) into an array, but you don't use array() to do that. You use PHP's built-in function called explode() -> http://php.net/explode like this...

<?php
$string = 'a,b,c,d,e';
$myarray = explode(',' $string);
foreach ($myarray as $k => $v) {
    print $v .'<br />';
}
?>

I think that is the problem you're having

edited Feb 4, 2014 at 20:22

answered Feb 4, 2014 at 20:07

Armin

1,7564 gold badges19 silver badges35 bronze badges

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

1 Comment

user3186181 Over a year ago

That has done just the job! You are a gentleman and a scholar

Collectives™ on Stack Overflow

Grabbing array from database, then getting information using each array value

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