[Show more than 1 rows in a order]

Thankyou so verry much this helped me alot

[Show more than 1 rows in a order]

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.