1. Improved DAO.class.php, when no results returned for "select" sql, return false;

[acontent.git] / docs / include / classes / DAO / DAO.class.php

diff --git a/docs/include/classes/DAO/DAO.class.php b/docs/include/classes/DAO/DAO.class.php
index 8516b95..905a4b3 100644 (file)
--- a/docs/include/classes/DAO/DAO.class.php
+++ b/docs/include/classes/DAO/DAO.class.php
@@ -52,17 +52,22 @@ class DAO {
                $result = mysql_query($sql, $this->db) or die($sql . "<br />". mysql_error());
 
                // for 'select' SQL, return retrieved rows
-               if (strtolower(substr($sql, 0, 6)) == 'select' && mysql_num_rows($result) > 0) 
+               if (strtolower(substr($sql, 0, 6)) == 'select') 
                {
-                       for($i = 0; $i < mysql_num_rows($result); $i++) 
-                       {
-                               $rows[] = mysql_fetch_assoc($result);
+                       if (mysql_num_rows($result) > 0) {
+                               for($i = 0; $i < mysql_num_rows($result); $i++) 
+                               {
+                                       $rows[] = mysql_fetch_assoc($result);
+                               }
+                               mysql_free_result($result);
+                               return $rows;
+                       } else {
+                               return false;
                        }
-                       mysql_free_result($result);
-                       return $rows;
                }
-               else
+               else {
                        return true;
+               }
        }
 
 }