Selecting a random row from the 5 most recent entries

[DrDankWD]

Hello,

I am trying to figure out something for a news module. I would like to display a random news article from the database, but I would like to limit it to the 5 most recent news posts.

 

For instance:

  There are 25 dated articles in the database, Out of the 5 most recent I would like to pick one to display.

 

I am not sure how to write this query, any help would be much appreciated.

 

Thanks

DrDankWD

[Barand]

<?php

$x = rand(0,4);

$sql = "SELECT * FROM  news ORDER BY newsdate DESC LIMIT $x, 1";

[DrDankWD]

Thanks a bunch, it worked beautifully.