SQLTeam.com | Weblogs | Forums

Update textbox value to database table column

sql2008

#1

when I enter 0 in the update textbox and click on submit button...The Download_status must get changed to 1...and vice versa.. am using SQL server 2008 and PHP.. The Text box value must get reflected in the DATABASE table Download_status Is this possible Can anyone help me out...

Output sample:

Branch_code -> AM , AM , AM

Palmtec_id ->AM06 , AM07 , AM08

Download_status-> 0 , 1 , 1

Query:

select
Branch_code,Palmtec_id,Download_status from tbl_download where
Branch_code='AM' and Palmtec_id='AM06'
order by Branch_code,Palmtec_id