boardom

[nicolai]

hi everyone
hope some of you can help me.
I'm trying to extract the date of the latest post and put it on my index page for a "last update" thing, but with no luck though.

the script i'm trying looks like this...

## Functions to print the date and time of the last post [/speza]
function posts_lastdate($d="") {
global $id,$dateformat;
$query = "SELECT post_date FROM b2posts WHERE b2posts.ID=$id ORDER BY b2posts.post_date DESC LIMIT 1;";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
if ($row) {
if ($d=="") {
echo mysql2date($dateformat, $row["posts_date"]);
} else {
echo mysql2date($d, $row["posts_date"]);
}
}
}

I've added this one to b2template.functions.php

and I'm calling it like this <?php posts_lastdate("F d."); ?>

the outcome though is like this "Warning: Missing argument 2 for mysql2date()" and I've been completely unable to do anything about it.

Can anyone help, I'm completely new to php.

/Nicolai

[stevem]

[nicolai]

thanks that helped me past the first hurdle although after editing the script I get this warning "mysql_fetch_array(): supplied argument is not a valid MySQL result" again I'm not quite sure what that means...

[stevem]

It means that the SQL is wrong. How about:

[nicolai]

YES thank you thank you thank you, though perhaps a simple error I really appreciate your help...
thanks...