By: Quzi
Date: 2003-05-11
Time: 05:59
|
UNIX_TIMESTAMP in mySql queery
I am be trying queery in mySQL but is no work. It gets lastlogin and puts it in last, but no converting is be done. If I doing this in regular program is works, but when trying in TBS is no work.
Here is what I is done:
$query = "SELECT *, UNIX_TIMESTAMP(lastlogin) as last FROM users order by userid";
$RecCnt = $ObjTBS->MergeBlock("blk", $cnx_id, $query, $PageSize, $PageNum, $RecCnt) ;
Thanking you with flipping toes.
Quzi
|