Hey Hey , I think I am getting closer here , after reading thru some of the php help files , I noticed that Lesane left out a " in his code line ,
Quote:
$updatestore = $DB_site->query_first("UPDATE user SET storep=storep+'$storeamount' WHERE userid='$bbuserinfo[userid]');
|
so I inserted it
Quote:
$updatestore = $DB_site->query_first("UPDATE user SET storep=storep+'$storeamount' WHERE userid='$bbuserinfo[userid]'");
|
and it did award points in a quiz i did for a test , but now it gave me this error
Quote:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /****/****/****/****/forums/admin/db_mysql.php on line 154
|
which when I look that up comes from this block of code :
Quote:
function fetch_array($query_id=-1,$query_string="") {
// retrieve row
if ($query_id!=-1) {
$this->query_id=$query_id;
}
if ( isset($this->query_id) ) {
$this->record = mysql_fetch_array($this->query_id);
} else {
if ( !empty($query_string) ) {
$this->halt("Invalid query id (".$this->query_id.") on this query: $query_string");
} else {
$this->halt("Invalid query id ".$this->query_id." specified");
}
}
return $this->record;
}
|
and line 154 is this line right here :
Quote:
$this->record = mysql_fetch_array($this->query_id);
|
Any help will be extremely apprecieated.