Changeset 1773 for trunk/admin/blog.func.php

Timestamp:

12/22/2008 09:43:41 PM (3 years ago)

Author:

robertb

Message:

fixed #206

File:

• trunk/admin/blog.func.php (modified) (1 diff)

trunk/admin/blog.func.php

@@ -214 +214 @@
 global $l, $categories;
 
-    $sql = "SELECT * FROM ".JLOG_DB_CONTENT." WHERE id = '".$id."' LIMIT 1;";
+    $sql = 'SELECT *, UNIX_TIMESTAMP(date) AS date FROM ' .
+                JLOG_DB_CONTENT . ' WHERE id = \'' . $id .
+                '\' LIMIT 1;';
 
     $blog = new Query($sql);