query for the register before the last.

[wobbie]

Any one can help?

I am trying to query and echo the register that is just before the very last.
This code gives me the very last register in the field id.

How can I do?


<?

$conn = mysql_connect("localhost", "root", "");
$sql = mysql_select_db( 'hillh' );
$sql2 = "SELECT * FROM admin ORDER BY id DESC LIMIT 1";
$result = mysql_query($sql2);
$found=0;

while($regset=mysql_fetch_object($result))
{
    $id = $regset->id;
    $id_headline = $regset->id_headline;
    $date = $regset->date;
    $id_news = $regset->id_news;

if(!$found)
{
$found=1;
echo "<table border=0 width='100%'>";

Thanks.

[Ninjakreborn]

First get the full number of id's in the array.
Then take the total number of id's.

Subtract 1, then run the same query, using the specific id, you got from the calculations.