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 display
field5, field6, and field7 of the member of the day?
Code:
$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:
Code:
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.