dispalying the database values after checking the checkbox

[prathikanoe]

hi.. i am new to php..i have one product form.i ahve 6 fields in myform...then there i am maintaining a checkbox after all the fields..even i am able to insert those vales into database.. Regarding retrival i need to display only the values which user ticked the checkbox.. how can i do that.. please help me.

[Jerico]

can you post your form code? I'm having trouble understanding your description. By 6 "fields" do you mean 6 options with a checkbox beside each one?

[prathikanoe]

ok..thanks or ur reply.. suppose i have 6 fields by name: ORDER,NAME,DESCRIPTION,NUMBER,XYZ,ABC..and also 6 corresponding check boxes for them..

<input type="text" name=ORDER />
<INPUT TYPE="CHECKBOX" NAME="CHECKBOX1" VALUE="1"/>


SAME THING IS THERE FOR REST OF 5.. BUT CHECKBOX NAME IS AS

CHECKBOX2,CHECKBOX3,CHECKBOX4,CHECKBOX5..


so my aim was IF i select ORDER checkbox1 and DESCRIPTION checkbox3 .. in the front end i need to display only THE VALUES WHICH I SELECTED IN THE CHECKBOX..

SO HOW I NEED TO WRITE THE QURY TO RETRIVE FRM DATABASE:

SELECT * FROM TABLE WHERE CHECKBOX1="1" OR HOW BECAUSE I AM SELECTNG MORETHAN ONE CHECKBOX S..SO HOW I CAN WRITE THE QUERY