From fc143e79a77973671b4a82e0cca817747e3b15d0 Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Fri, 16 Aug 2002 07:28:27 +0000
Subject: - Changed a MySQL-ism to be ANSI SQL/PostgreSQL compliant.  Patch by
 jaa.

---
 modules/user/user.module | 12 ++++--------
 1 file changed, 4 insertions(+), 8 deletions(-)

(limited to 'modules/user/user.module')

diff --git a/modules/user/user.module b/modules/user/user.module
index 6108dd47d..1d8959a2b 100644
--- a/modules/user/user.module
+++ b/modules/user/user.module
@@ -276,12 +276,10 @@ function user_fields() {
   static $fields;
 
   if (!$fields) {
-    // is this ANSI? perhaps this should go in the database include...
-    $result = db_query("SHOW FIELDS FROM users");
-    while ($data = db_fetch_object($result)) {
-      $fields[] = $data->Field;
-    }
+    $result = db_query("SELECT * FROM users WHERE uid < 0");
+    $fields = array_keys(db_fetch_array($result));
   }
+
   return $fields;
 }
 
@@ -1965,8 +1963,6 @@ function julia_user($type, $edit, &$user) {
     }
   }
 </pre>
-
-<p>Extra credit: use the <a href="http://cvs.drupal.org/viewcvs.cgi/contributions/modules/hotlist/?cvsroot=contrib">hotlist.module</a> to provide Julia users a mechanism for bookmarking their favorite recipes.</p>
   <?
 }
-?>
\ No newline at end of file
+?>
-- 
cgit v1.2.3