Hi all

ive got a timestamp column in one of my tables (using mysql). ive read that you cant directly query these columns and that you have to convert it using UNIX_TIMESTAMP. so this is the code I have:

Code:
<?php

include 'dbconnect.php'; 


$result = mysql_query("SELECT UNIX_TIMESTAMP(`created`), fk_memberid2, subject, status1 FROM technicalproblems");
print "<h1>Customer List</h1>\n";
    if (mysql_num_rows($result)) {
        print "<TABLE BORDER=\"1\"><TR STYLE=\"font-weight: bold;\"><TD>Created</TD><TD>Member ID</TD><TD>Subject</TD><TD>Status</TD></TR>";

        while($row = mysql_fetch_assoc($result)) {
            extract($row);
            print "<TR><TD>$created</TD><TD>$fk_memberid2</TD><TD>$subject</TD><TD>$status1</TD></TR>";
        }
    
        print "</TABLE>";
    }
?>
but as expected the "created" field isnt displaying anything. Also how would i go about running a query like: display records from the last x amount of days, because its abit different than access and im pretty new to this.

appreciate any help.