(no commit message)

[mecon/intranet.git] / lib / noticia.php

diff --git a/lib/noticia.php b/lib/noticia.php
index 50e89704f530963bd0b9c5f64f852490b0ddb0f1..0b37c92ecc67368862d8c1f45fe89f83e92abfc4 100644 (file)
--- a/lib/noticia.php
+++ b/lib/noticia.php
@@ -55,9 +55,11 @@ class noticia {
     {
         $this->noticia = $noticia;
         $db = MEconDAVDB::Connect();
     {
         $this->noticia = $noticia;
         $db = MEconDAVDB::Connect();

-       $query = "SELECT headline, title, abstract, article, publication_date
-                 FROM Articles
-                 WHERE Article_id = $noticia";
+       $query = "SELECT A.headline, A.title, A.abstract, A.article,
+                        A.publication_date, S.description
+                 FROM Articles A, Sections S
+                 WHERE Article_id = $noticia
+                 AND A.section_id = S.section_id";

        $result = $db->query($query);
        $row = $result->fetchRow();
        $this->titulo = $row[0];
        $result = $db->query($query);
        $row = $result->fetchRow();
        $this->titulo = $row[0];


@@ -65,6 +67,7 @@ class noticia {
        $this->sintesis = $row[2];
        $this->texto = $row[3];
        $this->fecha = new Date($row[4]);
        $this->sintesis = $row[2];
        $this->texto = $row[3];
        $this->fecha = new Date($row[4]);

+       $this->seccion = $row[5];

     }
     // -X2C
 
     }
     // -X2C
 


@@ -123,5 +126,16 @@ class noticia {
     }
     // -X2C
 
     }
     // -X2C
 

+    // +X2C Operation 191
+    /**
+     * @return void
+     * @access public
+     */
+    function getSeccion() // ~X2C
+    {
+        return $this->seccion;
+    }
+    // -X2C
+

 } // -X2C Class :noticia
 } // -X2C Class :noticia

-?>
+?>
\ No newline at end of file