SQL row name for thread date

[anaesthetics]

Hi,

I'm currently writing a script that will display updates I post in my site updates forum inline with my news page (remote from vbulletin). I have been able to successfully list all posts in that forum, but haven't been able to locate the SQL row name for the date that the threads were created. I thought maybe it was simply $row["date"] but no dice.

Can anyone help me out?

Thanks a lot

[TheRed]

Have you tried using $row['dateline'] ?

[anaesthetics]

Thanks for the reply. I tried dateline and it outputted strings of numbers such as: 1177397899, 1177167454, 1175904202 . Any idea how I could get these to translate into a normal date? Such as day, month, year.. etc.

Thanks for your help.

[TheRed]

You could try using the vbdate function. Usage explanation can be found on the includes/functions.php file.

Alternatively you can use the www.php.net/date function.

[anaesthetics]

Man, I'm in a total bind. I looked at functions.php and I don't think that's going to work for me. How would I use the date() function to translate that date? Can you tell me what format a date like "1177397899" is in? I've never seen anything like it before. If I know the format, maybe I can find a solution for translating it into another format.

Thanks

[Dismounted]

PHP Code:

date("DATEFORMAT", $row['dateline']) 


Replace DATEFORMAT with the format you would like (php.net/date).