Not inserting into db

[Phpfr3ak]

All the variables are set for sure, anyone have any clue why the following isnt inserting anything into the db?

 

        //### Query to insert new item into the database table "items"
$query = "INSERT INTO `items`(`name`,`image`,`description`,`description2`,`description3`,`ItemType`,`cash_price `,`credit_price `,`GrowAmount`,`SellAmount`,`MaxOff`,`MaxDef`,`MaxHoes`,`Attack`,`Defense`,`Prestige`,`SafeLimit`,`ProductionQuality`,`ProductionWeight`,`HoDrugUsage`,`HoIncome`,`PurchaseDiscount`,`Informants`,`Pimpness`,`SalesPrice`,`SalesWeight`,`TroopDiscount`,`NotoReq`,`SCReq`,`PRReq`,`Buyable`,`ClassSpecific`,`Sellable`,`Multiple`) VALUES('{$name}','{$image}','{$description}','{$description2}','{$description3}','{$ItemType}','{$price}','{$creditprice}','{$GrowAmount}','{$SellAmount}','{$MaxOff}','{$MaxDef}','{$MaxHoes}','{$Attack}','{$Defense}','{$Prestige}','{$SafeLimit}','{$ProductionQuality}','{$ProductionWeight}','{$HoDrugUsage}','{$HoIncome}','{$PurchaseDiscount}','{$Informants}','{$Pimpness}','{$SalesPrice}','{$TroopDiscount}','{$NotoReq}','{$SCReq}','{$PRReq}','{$Buyable}','{$ClassSpecific}','{$Sellable}','{$Multiple}'";

        //### Execute the above query
        mysql_query($query);

[SergeiSS]

First of all you have to

 

echo $query;

and then show here the result.

 

Also it could be nice to start it in this way

mysql_query( $query ) or die( mysql_error());

If you have an error message - also show it here.

[Pikachu2000]

Add some logic to report mysql errors if the query fails, and to report if a record wasn't inserted. Something along these lines:

 

if( mysql_query($query) ) {
     if( mysql_affected_rows() < 1 )  {
          echo "Query ran, but inserted no record.";
     }
} else { 
     echo "<br>Query $query<br>Failed with error: " . mysql_error() . '<br>';
}

[Phpfr3ak]

Fixed cheers guys, both of the solutions helped a great deal