This SHOULD work, you don't need ' or ` unless the names have spaces or wierd charactors, so you should always use the for WHAt you insert of course because you don't always know what it will be in DB systems:
PHP Code:
$queryprod = "INSERT INTO product (stock_num, prod_s, prod_nam, thread_id, dim_h, dim_w, dim_l, prod_weigh, prod_cas) VALUES ('$prod_stocknum', '$prod_series', '$prod_name', '$t', '$prod_height', '$prod_width', '$prod_length', '$prod_weight', '$prod_case');";
$resultprod = mysql_query($queryprod) or die ("Error in query: ". mysql_error());