take for example you have a table like this in your database:
news { id, title, article, author, date }
when you create a new entry, you will want to do:
$date = date("y-m-d");
$title = "test";
$article = "testing 1 2 3";
$author = "yourname";
mysql_query("insert into news(title,article,author,date) values('$title','$article','$author','$date')");
then to get the info back, you want to:
$query = mysql_query("select * from news order by date limit 7");
while($result = mysql_fetch_array($query)){
echo $result['title']."<BR>";
echo $result['article']."<BR>";
...etc...
}
the * just means that you want to select all the fields in that table.
to show just one at a time, you would want to do something like:
select * from news where id = '$id';
where $id is the field you want to pull out of the database.
also, to make sure it pulls the newest ones, you will want to test the order by date ... it will either be:
order by date asc
or
order by date desc
