UNIX_TIMESTAMP sloooows everything down

scrupul0us

$result = mysql_query("SELECT user, title, UNIX_TIMESTAMP(time) as time, comment FROM news");

will cause my page to take FOREVER to load... if i take that function out the page loads SOOO much faster... whats the PHP end equivalent of that function?

also, why would that function caus such a huge slow down? i only have two records in the table and its taking nearly 20+ seconds to reload the page... its the only DB on the server and theres no other traffic

Installer

Change the alias to something besides "time" and see if it helps. Might, might not.

The php equivalent is "strtotime($mysql_time)".

bradgrafelman

Also try surrounding the column name(s) in backticks:

... UNIX_TIMESTAMP(`time`) AS `unix_time`, ...

EDIT: What column type is 'time' ?

scrupul0us

column time is mysql 'timestamp' type

scrupul0us

Installer wrote:
Change the alias to something besides "time" and see if it helps. Might, might not.

The php equivalent is "strtotime($mysql_time)".

how would u get a date output similar to:

date("m/d");

from that string?

Roger_Ramjet

Which string?

If you want to get m/d from the db then use mysql date_format in the query.

If you want to get it from strtotime($mysql_time) then don't use strtotime in the first place. (the opposite of strtotime is getdate)