Is this SQL query correct?

[powerful_rogue]

Hi Lynne,

Thanks for your reply. I changed it to below however it now comes back with the following error

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING

PHP Code:

$wturid = $db->query_first("
SELECT userid 
FROM useractivation 
WHERE activationid = '" . $db->escape_string($vbulletin->GPC['i']) . "'
AND emailchange=0;
    ");

$username = $db->query_first("
SELECT username 
FROM user 
WHERE userid = $wturid['userid'] 
    ");