CODEWITHSUNDEEP
phpmysqlfunction
user2975652
user2975652

Reputation: 1

mysql_fetch_array not working inside function

I was trying to make a weighted avg. value for my 5 star rating script:

function raten($setvl)
{
    global $book_id, $resulten, $dbhandle;
    $resulten =  mysql_query("SELECT SUM(rate) 
                                FROM review 
                               WHERE rate = '$setvl' AND 
                                     book_id = '$book_id",
                            $dbhandle);
    $rowen = mysql_fetch_array($resulten);
    return $rowen['SUM(rate)'];
}

Can anyone explain what I'm doing wrong?

Upvotes: 0

Views: 130

Answers (1)

Ne Ma
Ne Ma

Reputation: 1709

You have missed a ' in your query. Change...

"SELECT SUM(rate) FROM review WHERE rate = '$setvl' AND book_id = '$book_id"

to...

"SELECT SUM(rate) FROM review WHERE rate = '$setvl' AND book_id = '$book_id'"

Upvotes: 1

Related Questions