MySQL and PHP Date Formt

[JamesU2005]

Can anyone tell me why it displays 01 Jan 1970 instead of my date in the database?

echo date('d M Y',$row['time']);

Seems to me it's ignoring the $row

 

[JamesU2005]

It's echoing the correct value on a seperate line (without the date function).

But when I try and format it as above it just reverts to 01 Jan 1970.

 

[JamesU2005]

Thanks for the reply but it's still the same result 01 Jan 1970.

Could it be a problem at the database end? Do I have to change my select statement at all?

Can't see anything wrong here?

 

[JamesU2005]

SELECT UNIX_TIMESTAMP(`Date`) AS `TimeStamp` FROM `Table`

Ok now I'm confused.

Here is my current Select statement:

SELECT comp, time, firstteam, secondteam FROM upcoming

Which I echo all the above including:

echo date('d M Y', intval($row['time']));

But still have the same problem.

 

[JamesU2005]

So how would I adjust me select and echo?

 

[JamesU2005]

$result = mysql_query("SELECT comp, UNIX_TIMESTAMP(time) AS stamp, firstteam, secondteam FROM upcoming");

while ( $row = mysql_fetch_assoc($result) ) {
    echo date('d M Y', $row['stamp']);
}

Thank you, thank you, thank you!

Can't believe something as simple as formatting a date caused some many problems.

Also thanks to all those that tried to help.