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.
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?