[SOLVED] wont update.

[grlayouts]

i have a query that wont add..

 

$pr = mysql_fetch_array(mysql_query("SELECT boost FROM boosts;"));


function price ($q)
{
    if ($q > 1000000) return 25;
    return ceil($q * -275 / 1000000 + 750) +$pr[boost];

 

everything a part from the last bit +$pr[boost]; adds together. when i print $pr[boosts] i get the correct 50. but it wont add.

 

 

any idea's?

[maexus]

One thing I noticed right away, $pr[boost]; should be $pr['boost'];

 

and it wouldn't hurt to have back ticks for your field and tables names in your query

[cooldude832]

well your function never defines $pr and if its in the global scope well then you can't get to it so directly in your function.

[grlayouts]

never mind im an idiot

 

global $pr;

 

because its outside..

 

thanks guys.