Simple INSERT problem

3s2ng

Hello

I have a simple INSERT PROBLEM

here is the scenario

 
<tr>
<td height="62" align="right" valign="top" width="30%">SIZES</td>
<td valign="top">
<table>
							<?
												$seek_size = mysql_query ("SELECT * from tbl_size");
							while ($sizes = mysql_fetch_object($seek_size)) 
							{
							$val_size= "$sizes->SizeCategory";
							$val_size.="-";
							$val_size.="$sizes->Size";
							?>
<tr>
<td>
<input type="checkbox" name="size[]"><?=$val_size?>
</td> <td>&nbsp; &nbsp; &nbsp; PRICE: <input type="text" name="price[]">
</td>
 </tr>
							<?
								}
							?>
</table>
</td>
 </tr>

With this code It will display 2 columns the first column is a checkbox and the other column is a textbox for prices

The size is related to price.

Now i am saving this to the database

for($x=0; $x<sizeof($size); $x++)
	{
	$sqlshirtsize2 = "insert into tbl_premadesizes (premade_shirtID, size, price) values('$id', '$size[$x]', 'price[$x]')";
	mysql_query ($sqlshirtsize2) or die ("err3:=" . mysql_error ());
	}

The problem is when i save run the insert query SOme of the value of text box is = 0. Isn't it that only the selected checkbox will be save together with the price but why is that the some of the value of the textbox is 0. This makes me sick. I cant figured out why. Any comments on my code and know where the bug is? thanks for the time

bradgrafelman

Comments on your code? Sure.

If you're just working with variables, i.e. '$val_size.="$sizes->Size";' and so on, don't use quotes.
If you're inserting a variable in the middle of a string, it's never a bad coding practice to escape out of the string in my opinion, i.e. 'echo "this is a " . $variable . " !";' and so on
'price[$x]' is missing a $ before price in your SQL INSERT query.
If you're storing ID's (i.e. premade_shirtID) why not use an INTeger type in SQL? If you did so, you'd have to remove the quotes around $id so it doesn't think you're giving it a string.