generating an array from mysql table

[ianco]

Hi all,

 

I want to create an array from the output of a table. In the table cell I have some numbers where for each number I would like to relate it to a value in another table. However using the code below I get Array ( [0] => "26","27","28","29","30","31" ) from the print_r($arr); meaning that $range ins't being treated as an array, and hence, the second query only gives one value.

 

$showIng = mysql_query("SELECT * FROM recipe WHERE name = '$dish'") or die(mysql_error());

$rowShowIng = mysql_fetch_assoc($showIng);

$range = $rowShowIng['keyno'];

$arr = array($range);
print_r($arr);

foreach ($arr as &$value) {
$getIng = mysql_query("SELECT * FROM keywords WHERE keyid = '$value'") or die(mysql_error());
$rowGetIng = mysql_fetch_assoc($getIng);
echo $rowGetIng['ingredient'];
}

 

So, I want to know how I can create the array from $range

 

Thanks

[AyKay47]

Learn to use JOINS

[ianco]

I'm not sure JOINS will work because the cell could contain e.g. "2,5,19,21"

 

so i can have $range = "2,5,19,21";

 

but I want to change that into an array $arr = array($range);

[AyKay47]

$range = $rowShowIng['keyno'];
$arr = explode(',', $range);
print_r($arr);

[ianco]

bingo, cheers