Help! Timestamp from MySQL date

[nylex]

Hi, I have a date from MySQL in the format "2002-11-16 16:42:56". How can I get the timestamp for this? Using strtotime() returns -1.

<?
	$time = "2002-11-16 16:42:56";
	$ts = strtotime($time);
	$newTime = date('l, dS Y - H:i:s', $ts);
	print($newTime);
?> 

Any help appreciated 🙂.

[[deleted]]

no, stay in sql :
select unix_timestamp('DATECOL') from 'TABLE' where id='ID';

[nylex]

Ok, thanks 🙂. Another problem: I'm taking data from the db from more than one column:

$Query = "SELECT Author,unix_timestamp(PostDate),Title,Post,ID FROM News ORDER BY PostDate DESC";
$Result = mysql_query($Query, $Connect);

while($row = mysql_fetch_object($Result))
{
	$Author = stripslashes($row->Author);
	$PostDate = $row->PostDate;
	$Title = stripslashes($row->Title);
	$Post = stripslashes($row->Post);
	$ID = $row->ID;
}

How do I store the timestamp in a variable?

[Weedpacket]

If "unix_timestamp(PostDate)" is not being called PostDate or unix_timestamp, you can name it somethig more familiar, by saying something like "unix_timestamp(PostDate) AS PostDate"

[nylex]

Originally posted by Weedpacket
If "unix_timestamp(PostDate)" is not being called PostDate or unix_timestamp, you can name it somethig more familiar, by saying something like "unix_timestamp(PostDate) AS PostDate"

Thanks!