获取结果并输出 mysql_从mysql中获取结果并将每个结果应用于变量并最终输出

所以我想要做的是：

运行以下查询：SELECT FW_ArtSrcLink FROM FW_ArtSrc WHERE OneSet =1输出两个结果：

我想将两个结果追加到$result变量中，并通过结果与$r中的结果(如图中所示为2)相互关联，然后输出$r的部分，从而生成

# Source of Article Info-->

$SrcTitle=$newsStory[$i]->title;

$SrcLink=$newsStory[$i]->link;

# Actual News Article Info -->

$title=$newsStory[$i]->title;

$desc=$newsStory[$i]->description;看起来像下面的完整代码，目前只从sports.yahoo.com/tennis/rss.xml的第二个结果中提取：

## Loop through results from mysql

try{

#connection string

// $dbconn = new PDO('mysql:host=localhost;port=3306;dbname=mydatabase',array(PDO::ATTR_PERSISTENT => true));

$dbconn = new PDO('mysql:host=localhost;port=3306;dbname=mydatabase','myuser','mypass',array(PDO::ATTR_PERSISTENT => true));

$q = $dbconn->prepare("SELECT FW_ArtSrcLink FROM FW_ArtSrc WHERE OneSet=1");

#call stored proc

$q->execute();

#get the rows into an array

$result = $q->fetchAll();

$newsStory[] = array();

foreach($result as $r){

$xmlUrl = $r['FW_ArtSrcLink'];

$ConvertToXml = simplexml_load_file($xmlUrl);

# -> Setup XML

$newsStory = $ConvertToXml->channel->item;

}

# -----> Load News Stories

for($i = 0;$i

# Source of Article Info-->

$SrcTitle=$newsStory[$i]->title;

$SrcLink=$newsStory[$i]->link;

# Actual News Article Info -->

$title=$newsStory[$i]->title;

$desc=$newsStory[$i]->description;

# Output Results ------------>

echo '

---

';

echo ''.'Title:'.$title.''.'(via: '.$SrcTitle.''.'
';

//echo 'Link:'.$link.'
';

echo 'Description'.$desc.'
';

##echo 'count '.count($result);

echo '

---

';

}

} // try我在这里做错了什么？

来自单个数据库结果的简单输出示例，我将其称为硬编码结果而不是动态使用

$xmlUrl ="http://edge1.catalog.video.msn.com/videoByTag.aspx?tag=Fox%20Sports_NBA%20news&ns=MSNVideo_Top_Cat&mk=us&sd=-1&sf=ActiveStartDate&vs=0&ind=&ps=&rct=&ff=88&responseEncoding=rss&title=FOX%20Sports%20Video%20on%20MSN:%20NBA&template=foxsports&p=foxsports";

$ConvertToXml = simplexml_load_file($xmlUrl);：