Ive got an associative array thats pulled from mysql results and id like to display results from the array. For some reason its just not printing the results. this is a var_dump of the associative array:
array(7) {
["id"]=> string(3) "143"
["url"]=> string(61) "http://news.bbc.co.uk/sport1/hi/football/eng_prem/9013345.stm"
["title"]=> string(78) "BBC Sport - Football - Sir Alex Ferguson warns Man Utd ahead of Liverpool game"
["excerpt"]=> string(138) "Carelessness must stop - Ferguson: Manchester United boss Sir Alex Ferguson warns his players to cut out the error... http://bb开发者_JAVA技巧c.in/9tDv0R"
["tweet_count"]=> string(3) "183"
["created_at"]=> string(10) "2010-09-19"
["media_type"]=> string(4) "news"
}
and this the code im using to TRY to process it:
while($row=mysql_fetch_assoc($search))
{
foreach($row as $key=>$value)
{
echo $value["title"]."<br/>";
}
}
With mysql_fetch_assoc you have one complete row in $row variable.
Then you're doing foreach on this variable, where keys are: "id", "url", "title" (and others), and values are corresponding to these keys.
Instead of $value['title'] use $value
while($row=mysql_fetch_assoc($search))
{
echo $row['id'].': '.$row['title'];
foreach($row as $key=>$value)
{
echo $key.': '.$value."<br/>";
}
}
You already have reached farthest end of the array. Try this:
foreach($row as $key=>$value)
{
echo $value."<br/>";
}
instead of
foreach($row as $key=>$value)
{
echo $value["title"]."<br/>";
}
How to get the array values you wanted
while($row=mysql_fetch_assoc($search))
{
foreach($row as $value)
{
echo "Title: ".$value['title']."<br />";
echo "Excerpt: ".$value['excerpt']."<br />";
echo "Title w/ Link: <a href=".$value['url'].">".$value['title']."</a><br />";
}
}
精彩评论