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
Code:
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?
because the html would look something like this
Code:
<select name="package">
<option value="pending">Pending</option>
<option value="completed">Completed</option>
</select>
and for each row that has this data i have this same html repeated so basically it would look something like this
Code:
<select name="package">
<option value="pending">Pending</option>
<option value="completed">Completed</option>
</select>
<select name="package">
<option value="pending">Pending</option>
<option value="completed">Completed</option>
</select>
<select name="package">
<option value="pending">Pending</option>
<option value="completed">Completed</option>
</select>
<select name="package">
<option value="pending">Pending</option>
<option value="completed">Completed</option>
</select>
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.
thank you soo much.
Join the friendly bunch on IRC...
having trouble updating with mysql
Hybrid Mode
