Looping news script.

Jboy56af

Hey... I have so far set myself up with a news script where you can enter news to the database via a form... But now I need to know how to make it display the data on the news page in the middle of HTML, 5 times. So if you have 20 rows, it just takes the 5 most recent rows and prints them.

If you could help that would be appreciated 😉

P.S.

So far I have it print ONLY the latest row.

altexis

Is your data saved in a database?

If it is your solution is a simple SQL addon:
"SELECT news FROM newstable ORDER BY date DESC"
would give you a query with your news in descending order where "news" is the field holding the content of the news, "newstable" is the table with all the data and "date" is the field of the post dates.

Provided you use MySQL you can limit your query by writting:
"SELECT news FROM newstable ORDER BY date DESC LIMIT 0,5"
where 0 is the starting index and 5 the number of rows of news

In other databases where the "LIMIT" command does not exist you will probably have to count them from within your script

Jboy56af

Okay...
BUT, If I do that and I put the same variable in 5 times will each variable be from a different row?

YES its from mysql

altexis

here is a code you could use with the above sql line:

$result=mysql_query("SELECT news FROM newstable ORDER BY date DESC LIMIT 0,5") or die(mysql_error());

while (list($newsLine)=mysql_fetch_array($result)) {

  echo "<p>".htmlspecialchars($newsLine)."</p>\n";

mysql_free_result($result);

In this example you use only one variable and the while loop will execute exactly 5 times

altexis

oooops... sorry for the mess above.. lets go again:

here is a code you could use with the above sql line:

$result=mysql_query("SELECT news FROM newstable ORDER BY date DESC LIMIT 0,5") or die(mysql_error());
while (list($newsLine)=mysql_fetch_array($result)) {
  echo "<p>".htmlspecialchars($newsLine)."</p>\n";
}
mysql_free_result($result);

In this example you use only one variable and the while loop will execute exactly 5 times