having trouble updating with mysql

sarmenhb · 11-17-2008, 02:19 AM

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.