A seemingly simple problem has had my head burning today. Any ideas please...
this outputs the results (41, 48, 71, 72, 73, 20, 39, 41, 48, 50, 71, 72,) but I don't want to output to the screen. I want to store all the results in an array to compare with other result sets and use in another select statement. I haven't been able to store more than the first result in a variable and any arrays come out empty. Thanks for any help.
Code: Select all
SELECT DISTINCT recoentryid FROM businessdetails WHERE category IN ('musician') AND country IN ('mx', 'qro')...(edited)
$result6 = mysql_query($query6, $recommendingpeople) or die(mysql_error());
$row6 = mysql_fetch_array($result6);
$rn6 = mysql_num_rows($result6);
if(isset($row6['recoentryid'])) {
do {echo $row6['recoentryid']; echo ", "; }
while($row6 = mysql_fetch_array($result6));
}