Show more than 1 rows in a order

[casperhollemans]

Hello, my name is Casper.

 

I'm createing a site where you can upload articles.

But for now I onley can show 1 article on the pages.

Does anyone knows how to show more articles?

 

My script what posts 1 article:

 

 

 

<?php

 

$username = "";

$db = "";

$hostname = ""; 

$password = "";

 

@mysql_connect($hostname, $username, '') or die("connectie mislukt");

 

@mysql_select_db("$db") or die ("could not connect dattabase");

 

$sql = mysql_query('SELECT * FROM home ORDER BY Date') or die ('Database Error()');

 

$id = 'ID';

$date = 'Date';

$title = 'Title';

$article = 'Article';

 

$rows = mysql_fetch_assoc($sql) or die ('Fetch Data Error()');

 

 

echo $rows[$title], '-', $rows[$date];

echo '</br>';

echo '</br>';

echo $rows[$article];

?>

 

and here's a ss of my DB table:

http://oi59.tinypic.com/2monptv.jpg

 

every article has to be in this order:

 

title - date

 

article

 

 

thank you in advance,

 

Casper Hollemans.

[Ch0cu3r]

 

But for now I onley can show 1 article on the pages.

Does anyone knows how to show more articles?

To show all the articles returned by your query you need to use a while loop passing mysql_fetch_array as the condition, Example

while($rows = mysql_fetch_assoc($sql))
{
    echo '<p>' . $rows[$title]. '-'. $rows[$date];
    echo '</br>';
    echo '</br>';
    echo $rows[$article] .'</p>';
}

NOTE: You should update your code to use either PDO or MySQLi now. The mysql_* functions are deprecated meaning they are no longer supported and could be removed from future versions of PHP.

Edited August 18, 2014 by Ch0cu3r

[casperhollemans]

Thankyou so verry much this helped me alot