TalkPHP - You are subscribed to this thread mysql update with multi fields

if i have something like this

Code:

status: &nbsp;

<select name="status">

<option value="pending">pending</option>

<option value="complete">complete</option>

<option value="declined">declined</option>

</select>



<br>



deadline: <input type="text" name="deadline">



<br>



status: &nbsp;

<select name="status">

<option value="pending">pending</option>

<option value="complete">complete</option>

<option value="declined">declined</option>

</select>



<br>



deadline: <input type="text" name="deadline">



<br>



status: &nbsp;

<select name="status">

<option value="pending">pending</option>

<option value="complete">complete</option>

<option value="declined">declined</option>

</select>



<br>



deadline: <input type="text" name="deadline">



<br>

how do i update each field with mysql update if the table structure looks something like this

Code:



id -- primary key, auto_increment

hash - varchar(100)

status -- varchar(25)

deadline -- date

and the values in this table looks something like this

Code:

id (1)

hash (90j23d093209jk309j3)

status (pending)

deadline(10/10/2008)



id (2)

hash (90j23d093209jk309j3)

status (pending)

deadline(10/10/2008)



id (3)

hash (90j23d093209jk309j3)

status (pending)

deadline(10/10/2008)

just a note the purpose of hash is an md5 or sha1 conversion of the users name to track the users information from table to table. and if i have like 100 people each with a different hash value i can track their information. but the problem i'm having is how do i update the fields if i have being displayed on the page?? u would it it would probably be with the id value but how or where do i display that to track that.??

Code:

this is what the sql update query looks like that im using



$status = mysql_real_escape_string($_POST['status']);

$deadline = mysql_real_escape_string($_POST['deadline'];

$user = $_GET['user']; 

mysql_query("update tbl_userpackage set status = '$status', deadline = '$deadline' where hash = '$user'");

but when i do the update the onyl value that comes in is the last item which is in id 3 all the other stuff doesnt go through