trying to get MySQL data in div

Question

I'm trying to get specific content from every single row in my MySQL database inside a div, however it only shows content from the row with the highest id value.

mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$query = "SELECT * FROM articles ORDER BY id";
$result = mysql_query($query) or die(mysql_error());

$count = mysql_num_rows($result);

while($row = mysql_fetch_array($result))
{
    $title = $row['title'];
    $summary = $row['summary'];
}
?>

<div class="content">
    <h2 class="titlecss"><?php echo ($title)?></h2>
    <p class="customfont"><?php echo ($summary)?></p>
</div>

Could anyone explain what I'm doing wrong here? I've been browsing the internet for 2 hours but can't seem to find anything...

You need to put your <div> inside the while loop

andrewsi
– andrewsi

2013-03-19 13:58:38 +00:00
Commented Mar 19, 2013 at 13:58 — andrewsi
– andrewsi, Commented Mar 19, 2013 at 13:58

SteveP · Accepted Answer · 2013-03-19 14:01:11Z

2

You need to output each div inside the while loop:

while($row = mysql_fetch_array($result))
{
    $title = $row['title'];
    $summary = $row['summary'];
    ?>
    <div class="content">
    <h2 class="titlecss"><?php echo ($title)?></h2>
    <p class="customfont"><?php echo ($summary)?></p>
    </div>
    <?php
}

answered Mar 19, 2013 at 14:01

SteveP

19.2k9 gold badges49 silver badges62 bronze badges

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

1 Comment

Tienus McVinger Over a year ago

That... is extremely weird. I did try this exact method, and it didn't work. Now it does. I must have made a typo or something. :-/ anyhow, thanks!

Luan Nico · Accepted Answer · 2013-03-19 14:02:52Z

0

You should do like this:

while($row = mysql_fetch_array($result)) {
   echo "<div class=\"content\">";
   echo "<h2 class=\"titlecss\">" . $row['title'] . "</h2>";
   echo "<p class=\"customfont\">" . $row['summary'] .  "</p>";
   echo "</div>";
}

The way you are doing it, you store every value in the same variable. So you put the first value, then the second, over the first, then the next, over the previous, and finally you write once (the last value).

answered Mar 19, 2013 at 14:02

Luan Nico

6,0533 gold badges33 silver badges63 bronze badges

Collectives™ on Stack Overflow

trying to get MySQL data in div

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related