[wwanthony]

Hi,
I have a script that selects data from mysql and echos the data in a table in input boxes ready to edit. The problem i'm having is that as there is multiple rows with one submit button, only the first row is being updated.

PHP Code:

if ($_POST[CALL] == 1){

while ($i < 11) {

$call = $_POST['del'.$i];

if ($call) {

$query = mysql_query("UPDATE ning SET Date='$Date', mer='$mer', Mae='$Mae', Technician='$Technician', Ord='$Ord', 

Post_Code='$Post_Code',  Act='$Act', Phone_Number='$Phone_Number', Numb='$Numb', Type='$Type', Comments='$Comments', 

Called='1' WHERE PDIID=$jobID");



    header("Location: Call.php?status=Success");

}

  }

$i++;

} 

The script above is where the fields to update the input box rows from the posted page. (what a mouthful???)
Please could anyone offer some advice as it surely must be just as easy to UPDATE multiple rows as it is to fetch multiple rows?

Best Regards,
Anthony

[Patiek]

The reason only the first row is being update, I think, is because you have the following:

PHP Code:

header("Location: Call.php?status=Success"); 

being called after the first mysql_query();

Thus, your script goes like this:

while
{
update_mysql;
redirect_to_another_page; die();
}

You need to put that header("Location...") outside of your loop.

And yes, you can update multiple rows in one query and you can optimize that query in various ways... but a lot of that is dependent on what you are updating / how you are updating / values you are placing.

[wwanthony]

Hi Patiek,
Thankyou for your reply, I thoroughly appreciate your help.

I can clearly see now that the forward shouldnt have been there and it should be outside of the loop.

Another thing I was wondering before i've actually tried it is:

I have put a checkbox for the rows to be selected for deletion in the form to be POST to this multiple delete or update script, I was wondering how should I name those checkboxes? I have put an $i increment so each rows checkbox would be named del1 del2 del3 etc etc. as you can see from the cod snippet I have tried to incorporate that in $call.

Would that be successful, other than it wouldnt be if there were more then 11 rows?

Hope i'm making sense, its just I dont completely understand it myself

Thankyou once again for your help.

[wwanthony]

Hi,
just tried it with:

}
$i++;
}
header("Location: CallOff.php"."$values");
}

It still just updates the first row?
Any further guidance would be most appreciated.

[Oras]

Hi,
can you tell me what $jobID is? you said you have 11 rows of data, so there should be different $jobID for each one isn't it?

[wwanthony]

Hi Oras,
Yes jobID is the row ID for each job, each are unique.

Thanks for your interest.

[Oras]

This the point, you are using the same JobID in the loop, I can't see any change happen to it through the loop, that's why you are getting only the first row updated

[wwanthony]

Hi Oras,
I have a different jobID send with a hidden input from the posted form on each row, how would I get the UPDATE query to recognise each individual jobID?

Thanks again.

[Oras]

Can you please put the source of your form here?

[wwanthony]

Hi Oras,
I'll have to wait till monday to get the source, was hoping to find a solution before then but i'll get back to you on monday.

Thanks very much.
Anthony