Create a page to show SQL Data

[cddw.ltd]

I'd like to create a single PHP page, which returns either a 0 or 1.

I think what I need is -

SELECT 'value' FROM 'forum_setting' WHERE varname='bbactive'

What I basically want to do, is have a page show 0 when the forum is closed or a 1 when its open (or whicever way around it is) because I'm going to use this number in an if statement on a different domain...

Anyone able to help?

[sebbe]

PHP Code:

require_once('./global.php');

$settings = $vbulletin->db->query_read("SELECT value FROM " . TABLE_PREFIX . "_setting WHERE varname = 'bbactive' LIMIT 1");

while($setting = $vbulletin->db->fetch_array($settings))
{
    $bbactive = $setting['value'];
}

echo $bbactive; 


[cddw.ltd]

Slight error,

"_setting WHERE


Didn't need the _ before the setting, otherwise, worked perfectly Thanks

[sebbe]

Oops.. typo.