Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By radu_d on
I am new to drupal. In my site I need a block on the right sidebar to display article of the day. Basically that can be a random through the articles that remains the same 24 hours. Do you know how can I achieve that?
Thanks,
Radu
Comments
PHP Block
Could you create a block with PHP code that utilised a database table.
The PHP code could query a DB table to see if there was a value for that day, if so show that view, if not update the DB with a new random value and show that article.
Other way would be a complex view (at a guess, I'm more traditional PHP/MySQL than Drupal world but learning too...). Perhaps a view would be best and someone more drupal qualified to chip in but I thought i'd try and help...