My PHP Scripts returns only one row from my table

Question

I got a problem while I'm trying to retrieve data from db!

Here's my parsing code that I've included & will get the data from MySQL table:

$select_posts = "select * from posts order by RAND() LIMIT 0,6";
$run_posts = mysqli_query($con,$select_posts);
while($row=mysqli_fetch_array($run_posts)){
    $post_id = $row['post_id'];
    $post_title = $row['post_title'];
    $post_date = $row['post_date'];
    $post_author = $row['post_author'];
    $post_image = $row['post_image'];
    $post_keywords = $row['post_keywords'];
    $post_content = $row['post_content'];
    $post_summary = $row['post_summary'];
}

As you can see I add the LIMIT 0,6 which means "Starts from 1st row & show 6 items from table"...

But I don't know why only 1 result appears.

This is the page that I show results of my table:

<div id="box">
                <div class="BJadidBold">
                <?php 
                if (mysqli_num_rows($run_posts) > 0){ 
                    echo "
                    <h1>$post_title</h1>
                    <p>$post_summary</p></br>
                    <a style='float:right;font-size:30px;margin-top:-30px;' href='blog_post_content.php?post_id=$post_id'>readmore</a>
                    ";
                }else{
                    echo "<h1>No posts yet!</h1>";
                }
                ?>
                </div>
            </div>

I want to show at least 6 items on my page. How can I be able to do that?

in your loop you overwrite each variable. you will end up with the last db row in each of those variables — user557846
– user557846, Commented Jan 24, 2016 at 20:44

score 1 · Accepted Answer · 2016-01-24 21:09:49Z

1

change the first block to not overwrite:

$select_posts = "select * from posts order by RAND() LIMIT 0,6";
$run_posts = mysqli_query($con,$select_posts);
$post=array();
while($row=mysqli_fetch_array($run_posts)){
    $post[$row['post_id']]['id'] = $row['post_id'];
    $post[$row['post_id']]['title'] = $row['post_title'];
    $post[$row['post_id']]['date'] = $row['post_date'];
    $post[$row['post_id']]['author'] = $row['post_author'];
    $post[$row['post_id']]['image'] = $row['post_image'];
    $post[$row['post_id']]['keywords'] = $row['post_keywords'];
    $post[$row['post_id']]['content'] = $row['post_content'];
    $post[$row['post_id']]['summary'] = $row['post_summary'];
}

then loop the results for display:

foreach($post as $p){
 echo "
 <h1>$p['title']</h1>
 <p>$p['summary']</p></br>
 <a style='float:right;font-size:30px;margin-top:-30px;' href='blog_post_content.php?post_id=$p['id']'>readmore</a>";
}

edited Jan 24, 2016 at 21:09

answered Jan 24, 2016 at 20:50

user557846

Sign up to request clarification or add additional context in comments.

1 Comment

Hello World Over a year ago

Thanks alot but I think I need to change $post['title'] to $p['title'] in order to do that for displaying results!

Collectives™ on Stack Overflow

My PHP Scripts returns only one row from my table

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related