Display entries in MySQL database table in php page

Question

I am trying to display all entries in MySQL database table in a php page, but for some reason it is only showing the most recent. I think there are 10 entries at the moment, although there will be more.

Here is my code:

<?php 

//connect to the server
$connect = mysql_connect("localhost","...","...");

//connect to the database
mysql_select_db("blog");

//query the database
$query = mysql_query("SELECT * FROM articles");

//fetch the results / convert results into an array

WHILE($rows = mysql_fetch_array($query)):

$article_id = $rows['article_id'];
$article_title = $rows['article_title'];
$article_content = $rows['article_content'];
endwhile;

echo "$article_id $article_title<br>$article_content<br><br><br>";

?>

Does anybody have any ideas?

Julio · Accepted Answer · 2013-09-16 19:14:08Z

7

Your code is correct, however it appears you are only echoing the last item in your results. Move your echo into your WHILE loop to print out all rows. Something like:

while($rows = mysql_fetch_array($query)) {

$article_id = $rows['article_id'];
$article_title = $rows['article_title'];
$article_content = $rows['article_content'];

echo "$article_id $article_title<br>$article_content<br><br><br>";

}

Otherwise the various article variables are reset, and only the last is output. With the modifications, for each row you will get an output.

answered Sep 16, 2013 at 19:14

Julio

2,3004 gold badges30 silver badges59 bronze badges

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

1 Comment

PK333 Over a year ago

Thank you! thats sorted the problem I was having :-)

Gar · Accepted Answer · 2013-09-16 19:14:42Z

2

change this

WHILE($rows = mysql_fetch_array($query)):

$article_id = $rows['article_id'];
$article_title = $rows['article_title'];
$article_content = $rows['article_content'];
endwhile;

echo "$article_id $article_title<br>$article_content<br><br><br>";

into this

WHILE($rows = mysql_fetch_array($query))
{
$article_id = $rows['article_id'];
$article_title = $rows['article_title'];
$article_content = $rows['article_content'];

echo "$article_id $article_title<br>$article_content<br><br><br>";
}

answered Sep 16, 2013 at 19:14

Gar

86213 silver badges20 bronze badges

Comments

kamal0808 · Accepted Answer · 2013-09-16 19:22:32Z

1

You are echoing outside your WHILE loop.

Corrected:

WHILE($rows = mysql_fetch_array($query)):

$article_id = $rows['article_id'];
$article_title = $rows['article_title'];
$article_content = $rows['article_content'];
echo "$article_id $article_title<br>$article_content<br><br><br>";
endwhile;

answered Sep 16, 2013 at 19:22

kamal0808

5251 gold badge8 silver badges22 bronze badges

Collectives™ on Stack Overflow

Display entries in MySQL database table in php page

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest