PHP File::GetByAssoc Examples

Example #1

File: File.inc.php Project: alcexhim/PhoenixSNS

 public function GetFilesByUser($user)
 {
     $query = "SELECT * FROM phpmmo_storage_files WHERE file_category_id = " . $this->ID . " AND file_creation_member_id = " . $user->ID . " AND file_deletion_member_id IS NULL AND file_deletion_timestamp IS NULL";
     $result = mysql_query($query);
     $count = mysql_num_rows($result);
     $retval = array();
     for ($i = 0; $i < $count; $i++) {
         $values = mysql_fetch_assoc($result);
         $retval[] = File::GetByAssoc($values);
     }
     return $retval;
 }