casperhollemans

Thankyou so verry much this helped me alot

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.