[PHP] MySQL timestamp to desired date function

[Cesar Aracena]

Hi all,

I have a a timestamp in a DB (14 digits) that I want to display like I
want in my pages. I tried to use strtotime, mktime and date functions
with no success... it always return the current timestamp instead of the
one I have stored. This is what I've done so far:

        for ($x = 0; $x < $num_rows; $x++)
        {
                $row = mysql_fetch_array($result);
                $date1 = strtotime($row[lugar_lastinsert]);
                $date2 = date("d \de m \de Y \a \l\a\s H:i:s",
mktime($date1));
                echo "<tr>";
                echo "<td>";
                echo $row[lugar_name]." - ".$row[lugar_specific];
                echo "</td>";
                echo "<td align=\"center\">";
                echo $date2;
                echo "</td>";
                echo "</tr>";
        }

How can I do this and make it work?

Thanks in advanced,

Cesar Aracena
www.icaam.com.ar

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php