print

[grlayouts]

any idea why

 

$sql = "UPDATE price SET cost = $q where ITEM = 'drugs'";

 

even print"$q"; doesnt show the price.

 

function price ($q)
{
    if ($q > 1000000) return 25;
    return ceil($q * -275 / 1000000) + 300;
}

$qtys = $q2;
foreach ($qtys as $q) 
{
    echo "$q :" . price($q) . '<br>';
}  
mysql_query('UPDATE players SET drugs = drugs + (drugfact*2), dpayout = (drugfact*2);');
mysql_query('UPDATE players SET credits = credits - (employees*wages)');
$sql = "UPDATE price SET cost = $q where ITEM = 'drugs'";

[code]

[/code]

[xyn]

I noticed your mysql syntaxs aren't correct. use or die(mysql_error());

[grlayouts]

didnt print anything.. any1?

[phpSensei]

didnt print anything.. any1?

 

Replace $q with a actually string or number, then use mysql_error()); to see your problem in the query.

 

Aslo:

 

change

$sql = "UPDATE price SET cost = $q where ITEM = 'drugs'";

To

$sql = "UPDATE price SET cost = '$q' where ITEM = 'drugs'";

 

 

[revraz]

Cant he just do

 

function price (&$q)    ?

 

[phpSensei]

Cant he just do

 

function price (&$q)    ?

 

 

I was correcting his SQL, and he can also do a function that he can just change the value everytime.