small...but deadly.

[Velocd]

Another quick question:

The following code is for the member of the day hack, and I'm trying to apply alittle more features to it.

Wouldn't the following code be acceptable to displayfield5, field6, and field7 of the member of the day?

$newmember=$DB_site->query_first("SELECT userid,username
                                        FROM user
                                       WHERE userid<>$daybits[1]
                                         AND (usergroupid=5
                                          OR usergroupid=6
                                          OR usergroupid=7
                                          OR usergroupid=2)
                                       ORDER BY RAND()
                                       LIMIT 1");

    $newtemplate=$thisdate.'||vb||'.$newmember['userid'].'||vb||'.$newmember['username'];

    $DB_site->query("UPDATE template
                        SET template='".addslashes($newtemplate)."'
                      WHERE templatesetid=-2
                        AND title='memberoftheday'");
    $memberoftheday['userid']=$newmember['userid'];
    $memberoftheday['username']=$newmember['username'];

    $newmember2=$DB_site->query_first("SELECT field5,field6,field7
                                             FROM userfield
	                                        LINE 85: WHERE userid='$memberoftheday['userid']' LIMIT 1");


    $memberoftheday['interests']=$newmember2['field5'];
    $memberoftheday['anime']=$newmember2['field6'];
    $memberoftheday['quote']=$newmember2['field7'];

This code gives me the following error:

Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in c:\apache\htdocs\index.php on line 85

Line 85 is marked.