Small Script Error

[Th3Boss]

I get this from the script below

Parse error: syntax error, unexpected T_VARIABLE in /home/[...]/priceupdate_cronjob.php on line 18

 

line 18 is

$change=mysql_query("UPDATE invtypes SET basePrice='$price' WHERE typeID='"$row['typeID']"';");

 

<?php
include_once("connect.php");

//Set tax, default is 5%.
$tax=0.05;

//This will spam the site to get prices.
$updateprices=$_REQUEST['updateprices'];
if($updateprices){
$query=mysql_query("SELECT * FROM invtypes WHERE published=1;");
while($row=mysql_fetch_array($query)){
$getfile="http://eve-marketdata.com/api/item_price.xml?type_id=".$row['typeID'];
$file=file_get_contents($getfile);
$xml=new SimpleXMLElement($file);
$price=$xml->price;
$pricechange=($price * $tax);
$price=($price+$pricechange);
$change=mysql_query("UPDATE invtypes SET basePrice='$price' WHERE typeID='"$row['typeID']"';");
}
}


?>

 

Anyone able to see whats wrong?

 

Thanks

 

KP: Removed url

[herghost]

try it without the " around "$row['typeID']"

[Th3Boss]

try it without the " around "$row['typeID']"

 

Then I get  Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING on line 18

[Pikachu2000]

WHERE typeID='{$row['typeID']}'