Problem with simple INSERT

[boomerang88]

Having a problem and I'm sure its something simple I'm just not seeing. Code makes it to and past my query and prints out affected rows with no errors.
Problem: values are not in database but variables will print out from the code so I know they are not empty..

foreach ($response->product as $product) {

$sku=$product->sku;
$categorie = "camping";
$ti=$product->ti;
$fdesc=mysql_real_escape_string($product->fdesc);
$list=$product->list;
$small=$product->sku . "SM.gif";
$large=$product->sku . ".gif";
$qty=$product->qty;
$mfg=$product->mfg;
$wt=$product->wt;

mysql_query("INSERT INTO products(productID,category,productTitle,description,list,smallPic,bigPic,stock,manufacturer,weight) VALUES ('$sku','$categorie','$ti','$fdesc','$list','$small','$large','$qty','$mfg','$wt'");

printf ("Updated records: %d\n", mysql_affected_rows());

echo $product->sku . " - " . $sku . "-" . $wt . "<br>";

}

Maybe just need some fresh eyes.
Thanks

[Dan Grossman]

Have you tried printing out the query you're executing and looking at it?

$query = "INSERT INTO products(productID,category,productTitle,description,list,smallPic,bigPic,stoc k,manufacturer,weight) VALUES ('$sku','$categorie','$ti','$fdesc','$list','$small','$large','$qty','$mfg','$ wt'";

echo $query;

mysql_query($query); 

At least two of your mistakes would become apparent... "stoc k" as a column name, "$ wt" as a value...

While it probably wouldn't cause a problem, are all these columns of type VARCHAR/TEXT? Numeric values shouldn't be enclosed in quotes as all your values are.

[boomerang88]

Thanks Dan, I'll try to print the query. The spaces were added by the forum post and I originally didn't have the quotes. Just was trying everything I could think of to troubleshoot it. I'll go give your ideas a shot.
Thanks

[boomerang88]

$query shows all data. Should be succesful but still hasn't been inserted into db???? Shows 28 rows affected. How wierd. I've added to the db manually but I'm trying to import an XML file. Everything works to here.
Any other thoughts?
Thanks

[boomerang88]

Also changed quotes on numeric columns.

[Dan Grossman]

28 rows affected should be a hint! Insert should produce only one row.

You're missing the closing ) at the end of the query