Hi all,

I need help with turning this query into something useful

SELECT fid FROM {files} WHERE filepath LIKE 'files/%' LIMIT 1

if (count(db_fetch_object(db _query("SELECT fid FROM {files} WHERE filepath LIKE 'files/%' LIMIT 1"))) == 1) {

The purpose is to determine if there is some files within the dir 'files' registered in the db. I'm stuck at the db_* stuff, any help would be greatly appreciated. See also http://drupal.org/node/98824 .

Thank you

--
Regards,
  Johan Forngren

   johan@forngren.com :: http://johan.forngren.com/