This will most likely come off as really stupid, but I'm still learning Xoops.

Basically I need to have a page run a quick check on a table in the database and return the result.

The page isn't part of any of my modules or anything like that, so I'm wondering can I just create the page, reference main_file, and get an instance of the database?

I've tried it, and when I run $result = $db->query($sql) I get a Resource ID #37. Which I think means it was ok, but when I try to do a db->fetchArray($result) there's nothing there..

in module "xoopscare" you can execute code for mysql

You know, it sucks being a dumbass sometimes. I just realised I was working off the wrong database. This one has no records, the right one has many..

So it works..

Learning too, so i need a good reply.
10q