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
[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]
[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
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
[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
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
Ave,
I have a table with one of the fields ³hired² having either of 3 values:
YES, NO, NULL
My application provides the administrator with all the records in the table
and I need to give him the ability to change the status of ³hired² to either
of the three values.
Previously I was using a Check
7 matches
Mail list logo
