Re: [PHP] Updating Multiple rows with Combo Box! *SOLVED*

2005-08-22 Thread Rahul S. Johari
Ave, Solved it! Echoing the results out instead of trying out Queries really helped. What I was basically doing wrong was, I did create an Array for the Values, but I needed to also create an Array for the ID's for each records, which I hadn't. This is the code I used for generating the Select

RE: [PHP] Updating Multiple rows with Combo Box!

2005-08-22 Thread Jay Blanchard
[snip] >YES >NO >On Hold But none of my Queries are working. What I want to do is, when the form is submitted, it should just simply update the Œhired¹ field with whatever value has been selected for that row in the Combo Box. [/snip]

RE: [PHP] Updating Multiple rows with Combo Box!

2005-08-22 Thread Jay Blanchard
[snip] register_globals are On. I think the problem lies in the fact that I'm trying to update multiple rows in the table, I'm not sure that my query with the UPDATE statement is updating all the rows with what is being set in the value of the Form Field. I'm not sure. [/snip] Echo the query befo

Re: [PHP] Updating Multiple rows with Combo Box!

2005-08-22 Thread Rahul S. Johari
Ave, register_globals are On. I think the problem lies in the fact that I'm trying to update multiple rows in the table, I'm not sure that my query with the UPDATE statement is updating all the rows with what is being set in the value of the Form Field. I'm not sure. On 8/22/05 9:39 AM, "Jay Bl

RE: [PHP] Updating Multiple rows with Combo Box!

2005-08-22 Thread Jay Blanchard
[snip] I guess the last query I tried was simply updating the database with the value of the Hired form field: $sql = "UPDATE contactdata SET hired='$hired' WHERE ID='$thisID'"; $result = mysql_query($sql) or DIE("Fatal Error: ".mysql_error()); I've tried using an array and running the q

Re: [PHP] Updating Multiple rows with Combo Box!

2005-08-22 Thread Rahul S. Johari
Ave, I guess the last query I tried was simply updating the database with the value of the Hired form field: $sql = "UPDATE contactdata SET hired='$hired' WHERE ID='$thisID'"; $result = mysql_query($sql) or DIE("Fatal Error: ".mysql_error()); I've tried using an array and running the q