TalkPHP - View Single Post - Adding data

Tanax · 01-25-2008, 11:12 AM

Yah, so in your case, you would want to do:

PHP Code:


			
$aSep = explode(',', $aQuery['actors']);

$aActors = array();
foreach($aSep as $iId) {
$sql = "SELECT * FROM `actors` WHERE `id` = '".$iId."' LIMIT 1";
$query = mysql_query($sql);

if($query) {
$aActors[] = mysql_fetch_array($query);
}
else {
echo 'Could not fetch data for actor id: ' .$iId;
}
}

foreach($aActors as $aActor => $aInfo) {
echo $aInfo['First Name'];
}

Where $aQuery is an array of the movie info..

01-25-2008, 11:12 AM	#7 (permalink)
Tanax The Prestige Join Date: Sep 2007 Location: Sweden, Stockholm Posts: 1,080 Thanks: 115	Yah, so in your case, you would want to do: PHP Code: $aSep = explode(',', $aQuery['actors']); $aActors = array(); foreach($aSep as $iId) { $sql = "SELECT * FROM `actors` WHERE `id` = '".$iId."' LIMIT 1"; $query = mysql_query($sql); if($query) { $aActors[] = mysql_fetch_array($query); } else { echo 'Could not fetch data for actor id: ' .$iId; } } foreach($aActors as $aActor => $aInfo) { echo $aInfo['First Name']; } Where $aQuery is an array of the movie info..