current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote -3 down vote favorite

I have this code here:

<?php foreach($blog_posts['post_category'] as $category) {  ?>

How can I get this to work?

Basically I have a database with all my blog posts within them, one of the columns is post_category I'm trying to make a list out of all these by a foreach statement that gets the results like so:

$data['blog_categories'] = $this->db->query("SELECT `post_category` FROM `blog_posts`");

This is codeigniter by the way... Then in my view I have the code:

<?php foreach($blog_posts['post_category'] as $category) {  ?>

I need to display each category in an li...

share|improve this question
    
Is that all of the code? What errors are you getting? –  WayneC Oct 5 '12 at 22:05
    
Get this to work doesn't give me any clues on what you want it to do or what's not working. –  Mihai Stancu Oct 5 '12 at 22:06
3  
You need to do the thing there. –  ultranaut Oct 5 '12 at 22:08
1  
@ultranaut - you mean the thing with the stuff? Or the other thing? –  David Grenier Oct 5 '12 at 22:12
1  
@DavidGrenier - Silly question.. obviously ultranaut meant the other thing with that thing on the top. Makes it much faster together with the other stuff. –  Erik Oct 5 '12 at 22:17
show 8 more comments

2 Answers

up vote 0 down vote accepted

You wanna use implode I think

$output = array();
forreach($blog_posts['post_category'] as $item){
    $output[] = "<li>$item</li>";
}
echo "<ul>".implode('',$output)."</ul>";

Or if you were just after the list items and not list just replace the last line with

echo implode('',$output);
share|improve this answer
add comment
up vote 0 down vote

Pretty sure what you're looking for is

$data['blog_categories'] = $this->db->query("SELECT DISTINCT `post_category` FROM `blog_posts`");
foreach ($data['blog_categories'] as $category) {
  echo "<li>$category</li>";
}

Me, I'd change $data['blog_categories'] to just $blog_categories or something, but I kept it as you had it so as not to confuse the issue.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.