Need help finishing...

[Cloudrunner]

	   $score = $DB_site->query_first("SELECT '$whichscore' FROM *tablename*_questions WHERE qid='$theqid'");

if ($bbuserinfo['usergroupid']==2)
{
$DB_site->query("UPDATE user SET question1='$theqid',score1='$score[$whichscore]' WHERE userid='$bbuserinfo[userid]'");
}

Any help?

Satan

Try changing the code thusly:

PHP Code:

$score = $DB_site->query_first("SELECT whichscore FROM *tablename*_questions WHERE qid = '"
                               .$theqid
                               ."'");

if ($bbuserinfo['usergroupid'] == 2){
  $DB_site->query("UPDATE user SET question1 = '"
                  .$theqid
                  ."', score1 = '"
                  .$score[whichscore]
                  ."' WHERE userid = '"
                  .$bbuserinfo[userid]
                  ."'");
} 


Of course I am assuming that $whichscore is a column name and not a variable that has been pre-defined previously in the code. If my assumption is correct then removing the "$" effectively turns whichscore into an array identifier.

If on the other-hand, $whichscore IS a variable, then I would do the code like this:

PHP Code:

$score = $DB_site->query_first("SELECT '"
                               .$whichscore
                               ."' FROM *tablename*_questions WHERE qid = '"
                               .$theqid
                               ."'");

if ($bbuserinfo['usergroupid'] == 2){
  $DB_site->query("UPDATE user SET question1 = '"
                  .$theqid
                  ."', score1 = '"
                  .$score[$whichscore]
                  ."' WHERE userid = '"
                  .$bbuserinfo[userid]."'");
} 


Lemme know if this helps or if I'm just blowing smoke up my own arse. I could probably figure it out with you if I had abit more reference code to go by...

p.s. I always break out of quotes when calling variables, just for my own piece of mind. I know you don't have to, but I do unless I'm required to not do it.