Newbie Question

[sambah]

I've decided to make a fantasy football/sports mod for vb 3.5.4

I'm quite new to php and a complete novice with vb.

First stage went ok. Users can now register for the fantasy football league. Now I'm onto the main page.

What I'm trying to do with this code is tell users who havn't signed up for the league yet to go to the signup page, and users who have should proceed to the main page.

// ############################# START MAIN PAGE ###############################

// Check whether the user has registered for the game
if (!$vbulletin->GPC['do'])
{
	if ($db->query_first("SELECT * FROM footy_registration WHERE userid != " . $vbulletin->userinfo[userid] . ""))
	{
		standard_error(fetch_error('footy_youneedtoregister'));
	}
		else
	{
		eval('print_output("' . fetch_template('footy_main') . '");');
	}
}

This code in theory should check whether their userid from the vb userinfo table is present and matches their userid in the game registration table.

Unfortunately it doesn't work. Even if they have signed up it still displays the younneedtoregister message

Any ideas?

Sorry:

PHP Version: 5.1.4
SQL: 4.1.19