I have a simple MYSQL DB listing 30 articles.
We would like to display ten different articles every six months.
How could we do this?
This is the code which I have so far which isn't near completion but my hang was to set the pointer back to the start of the articles when reached 30, also to increment the start by 10 every six months.
$unitStart ='1474657057';
$nowTime = time();
$interPassed = round( $nowTime - $unitStart );
$secToChange = '15552000';
$intv= $interPassed / $secToChange;
$str = 'SELECT * FROM tc_articals LIMIT 0,6';
$result = mysql_query($str)or die(mysql_error());
