UPDATE data in rows

bruceg

I am trying to update many records at once. For example:

CK RNK DATA1 DATA2 DATA3

[x] 1 DATA1 DATA2 DATA3
[ ] 2 DATA1 DATA2 DATA3
[ ] 3 DATA1 DATA2 DATA3

...

where CK [x] is a checkbox that is checked.

These records all display in a form, and I would like to be able to update all the records based on user input, and then pressing the submit button.

I have a loop that loops through the records, and updates the db, but for some reason it always blanks the fields in the loop. I don't think the right values are being passed to my update script properly. What is the best way to do this?

TIA.

amcgrath

can you paste the loop code here so we can see it?

bruceg

Ok. $chk_array is an array passed from the previous script, to determine how many times I need to loop. Maybe this is where I am going wrong.

--------CODE----------
$count = sizeof($chk_array);
$count = 0;

while ($count <=$size)
{

/ do our db update /

// create a variable for the db connection using @ to supress warnings
$con1 = mysql_connect("$hostName","$userName","$password") or
die("Couldn't connect to the database server - please try again or contact your database administrator.");

 // use a variable to hold the result of the selection query

$db1 = mysql_select_db($databaseName, $con1) or
die("Couldn't select the database - please try again or contact the db admin");

 // heres the actual insert statement, which will insert the jobs into the db for further ranking

 // use a variable for the rest of the db query

$result = mysql_query($sql1,$con1) or
die("Couldn't UPDATE the schedule! Please try again, or call the db admin");

$count = $count+1;
}

mrskhris

First of all, I would re-arrange the code as followed.
Second, are you really updating all records with the same values?

// use a variable to hold the result of the selection query

$db1 = mysql_select_db($databaseName, $con1) or
die("Couldn't select the database - please try again or contact the db admin");

--------CODE----------
$count = sizeof($chk_array);
Did you mean $size here?

$count = 0;

while ($count <=$size) {
/ do our db update /
// heres the actual insert statement, which will insert the jobs into the db for further ranking

$sql1 = "
UPDATE $drumtable SET
date = '$date',
time = '$time',
rnk = '$rnk',
job_desc = '$job_desc',
job_cunm = '$job_cunm',
close_1 = '$close_1',
job_id = '$job_id',
conv_date = '$conv_date',
lark_qty_1 = '$lark_qty_1',
lark_um_1 = '$lark_um1',
lark_sz1 = '$lark_sz1',
convhrs_1 = '$convhrs_1',
eaddtl_desc_1 = '$eaddtl_desc_1',
hf_01 = '$hf_01',
hot = '$hot'
WHERE id = $id_num
";
// use a variable for the rest of the db query
$result = mysql_query($sql1,$con1) or
die("Couldn't UPDATE the schedule! Please try again, or call the db admin");
$count = $count+1;
}

Anon

No, I'm not updating with the same values. I'll try the suggestion tomorrow a.m. Thanks for your help.

Anon

I forgot to mention in my previous post, that yes, I did mean $size=sizeof($chk_array);

bruceg

Well, I think I have it. The hint you gave me about updating everything with the same data was the clue. I needed to update based on the Unique field. Now my UPDATE statement looks like this: