Need some help

Okay I am creating this very simple content management system, and the news system in it isn't working correctly. Anyway, I need a way to show the last 5 articles submitted. So the code I have to do that is:

When I click submit, the index page won't show my first article, until I post another article after that. So if I have 4 articles, the 4th article won't show until I post a 5th one, and when I post a 5th one, it won't show until I post a 6th one.. and so on. What could be the problem? And also I don't think I save the form data in the database correctly. Here is the code, is it correct or not?

LIMIT 5 instead of LIMIT 0,5

Hi there!

just on a side note, $HTTP_POST_VARS is actually replaced by $_POST in PHP5 - so you should try to use $_POST instead. I'd also assign variables to the $_POST values and rewrite the above as such:

---

$title = $_POST['title'];
$category = $_POST['category'];
$article = $_POST['article'];

$newArticle = "INSERT INTO news (title,category,article) VALUES ('$title', '$category', '$article')";

$result = mysql_query($newArticle);

if (!$result) {
die('Could not load form: ' .mysql_error());
}

---

Cheers,

Mike

Oh really? I knew that method, the $_POST, I was just reading off of a tutorial on how to create a simple content management system online, so it was an old one, I didn't know they did the same thing, but now I know they do I will do it that way. Thanks a lot. And thank you also enigma.