pulling articles from mysql database with PHP

[mh8759]

Hi,

I have a database of articles with columns ID,Title,Text,Date etc..

I want to pull out certain number of articles that were added the last, for instance last articles. Then I want to display the title and text of the last one(or the most recent one if you want), while for other three I want to show only Date and Title.

It should look like this:

Title of the last one added into the database

Text...blablalblalbla...blalbla...
Text...blablalblalbla...blalbla...

10.11.2000 Some title
5.11.2000 Some title
3.11.2000 Some title

All these three should have links to the whole article.

I know I can pull out entries with
query = mysql_query(SELECT ID,Title,Text,Date FROM Articles WHERE CatID=2 ORDER BY Date DESC LIMIT 4), but I don't know how to access article by article. Are they stored in an array?

Any help would be appreciated,
thanks
Mare

[DarkOps]

<?php
$news_query = mysql_query("SELECT * FROM Articles WHERE CatID=2 ORDER BY Date DESC LIMIT 4");

while ($row = mysql_fetch_array($news_query))
{
$id=$row["ID"];
$title=$row["Title"];
$text=$row["Text"];
$date=$row["Date"];
echo ("- <a href=http://www.you.com/articles.php?ID=$id>$title</a> - $date<br>");
}
?>


Read a tutorial before you post in the future. There is a good one at sitepoint.com

[mh8759]

thanks!