[JulianD]

and for the last post date, it's a little complicated but here is it:

replace in the query dateline to lastpost.

Now here's the tricky part.

Put this

$gelen[4] = date("m-d-y",$gelen[4]);

Above this:

if ($ii % 2) {$tdcolor="#FFFFFF";} else {$tdcolor="#eeeeee";}

And then you can use $gelen[4] anywhere in the script and you will get the last post date.

Hope this works.