can't insert hidden field into table

[Anon]

I had problems to insert hidden field data into mysql table. Partial code like

<tr><td width=550>
<input type=hidden name=field1 value=50>
</td></tr>
<tr><td width=550>
<input type=hidden name=field2 value="test">
</td></tr>
<tr><td width=550>
<input type="text" name=field3 >
</td></tr>

My php partial code like

insert into tablename(field1, field2, field3)
values('$field1','$field2','$field3');

But none of data was inserted into tablename. However, if I removed all hidden fields, rest of codes works well.

Really appreciate your suggestions,

[Anon]

i am not a mysql guy, but i think due to your field1 is an integer, it should be

insert into tablename(field1, field2, field3)
values($field1,'$field2','$field3');

hui

[Anon]

I tried couple of ways, but simply my hidden data can't be inserted into my table. Also cause all insertion is failure. If no hidden field, script works fine.

Any suggestions are appreciated!

[rrijnders]

I think this is yet another case of <i>single quotes killing the variable</i>.

You have to concatenate the single quotes around your data values. The way you have it, the values of the variables can not be de-referenced. Also, if <b>field1</b> in your table <i>is</i> an integer (as Hui guessed) then don't use any quotes around the value:

<font color=blue>
$sql = "insert into tablename(field1, field2, field3)" .
&nbsp;&nbsp;&nbsp;" values($field1,'" . $field2 . "','" . $field3 . "')";
</font>

-- Rich