I only have a basic understand of PHP as of know so be gentle.
I recently completed a tutorial in which I built an extremely simple content management (aka news) script. I have it to where I can create articles into a database, and I have also wrote code which will show the newest article I have written. This is that code.
//Generate the query
$query = “SELECT title, content FROM news ORDER BY id DESC”;
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
// get resultset as object
$send = mysql_fetch_object($result);
// print details
What I want is to make a code that will show the second to newest article. I want it to be a completely different piece of code, because I want to add it to a different location. I have played around with it a little, but not really made any progress. If I left out any additional info needed let me know.
Any help would be greatly appreciated.