my mind wasnt working when i coded the data that gets inserted but this is what the table looks like
btw, that image is two tables joined together.
what my problem is , is that what type of query do i write if i want to change one of the rows because what is happending is when i write something like
mysql_query("update tbl_userpackage set status = 'completed' where hash = '$hash'");
what that is doing is its updateing all the rows setting the status to be completed instead of just one. makes sense that its a bad query but the data that you see such as status its set in a selection drop menu and the deadline is in a textbox so how do i write the html to target the individual row that i want? the only possible way that i see to target the individual row is to grab the id but where would i set that value of id?
as you see each selection box name has the same name because i have it being repeated only for the one user who has whatever package for themselves. the value of hash is only a sha1 conversion of the persons username, that is how i am tracking the users information from table to table.
please if u can give me a solution i would greatly appreciate it, no one has been able to help me out. i am loosing it.