Only update certain rows in database

pb1uk

Hello all,

I am trying to update all records held in a database, however i only want to update 1 field for each record, this will be based on a selection from a drop down menu. For example in a drop down menu i will have

field 1
field 2
field 3
field 4

and a go button. When the user selects an item from the drop down menu and hits go the item they selected will be passed onto the next page. On the next page i only want to be able to update the field selected in the menu on the previous page.

Is this possible? I'm quite confused and lost! Any help would be greatly appreciated,

Thanks

Pikachu2000

Yes, it's possible.

$query = "UPDATE table SET $field = $value"; with $field as the value of the dropdown from the previous form, and $value based on the input from this form. This will update all records in that table to have the new value in the specified field.

pb1uk

Pikachu2000;10947429 wrote:
Yes, it's possible.

$query = "UPDATE table SET $field = $value"; with $field as the value of the dropdown from the previous form, and $value based on the input from this form. This will update all records in that table to have the new value in the specified field.

Thanks, that sounds like what i need to do.

On the update page i want to display all the records and have a field where i can enter the new value.
How would i do the query to get the fields from the database based on the drop down menu selection?

AlexKann

Pikachu2000;10947429 wrote:
Yes, it's possible.

$query = "UPDATE table SET $field = $value"; with $field as the value of the dropdown from the previous form, and $value based on the input from this form. This will update all records in that table to have the new value in the specified field.

Hi, I have the same code in my PHP pages to uptade my tables, but...
I've created a secondary PHP page with access to just a few field in the record to edit, but, when I apply the update, it does change the info, but... all other fields not available are deleted of the talbes' record.

How can I update just certain field in the record leaving the rest intact?

I use this to update the table...

$sql = "update intake_easy set medicare_name = '".$medicare_name."',dob = '".$dob."',state = '".$state."',p_insurace = '".$p_insurace."',ssn = '".$ssn."',pre_status = ".$pre_status.", pre_status_reason = '".$pre_status_reason."',K0011 = '".$K0011."',K0823 = '".$K0823."',K0014 = '".$K0014."',K0825 = '".$K0825."',K0800 = '".$K0800."',K0827 = '".$K0827."' ,parteadate = '".$parteadate."' ,partebdate = '".$partebdate."', v_note = '".$v_note."' where id = ".$intake;
$result = mysql_query($sql,$conn) or die (mysql_error());;

There are about 20 field more, and all of them are deleted (updated to blank) when I apply the update, is there any way to leave them with out change??

Alex

Weedpacket

If a field's variable is blank, don't put anything in the update statement to update that field (equivalently, only add its bit to the update statement if the variable is not empty).

$sql = "";
$dob=trim($dob);
if($dob!="") $sql .= ", dob='".$dob."'";
//...
$sql = ltrim($sql, ','); // Because there'll be a stray comma at the beginning that we don't want.
if($sql=="")
{
// Nothing was supplied! Everything is blank!
}
else
{
   $sql = "Update intake_easy .... $sql ... where id=".$intake;
   $result = /*etcetcetc...*/;
}

Note too that with so many variables, an array (such as the one you're getting these variables from) is almost certainly much easier to work with. You can then use loops, for example, rather than copy-and-pasting the same code over and over (which is a sure sign that you're doing it wrong because doing the same thing over and over is what computers are for), and localise where changes need to be made for future developments.

Pikachu2000

AlexKann;10947458 wrote:
Hi, I have the same code in my PHP pages to uptade my tables, but...
I've created a secondary PHP page with access to just a few field in the record to edit, but, when I apply the update, it does change the info, but... all other fields not available are deleted of the talbes' record.

How can I update just certain field in the record leaving the rest intact?

I use this to update the table...

$sql = "update intake_easy set medicare_name = '".$medicare_name."',dob = '".$dob."',state = '".$state."',p_insurace = '".$p_insurace."',ssn = '".$ssn."',pre_status = ".$pre_status.", pre_status_reason = '".$pre_status_reason."',K0011 = '".$K0011."',K0823 = '".$K0823."',K0014 = '".$K0014."',K0825 = '".$K0825."',K0800 = '".$K0800."',K0827 = '".$K0827."' ,parteadate = '".$parteadate."' ,partebdate = '".$partebdate."', v_note = '".$v_note."' where id = ".$intake;
$result = mysql_query($sql,$conn) or die (mysql_error());;

There are about 20 field more, and all of them are deleted (updated to blank) when I apply the update, is there any way to leave them with out change??

Alex

You probably should start another thread for this, but yes, you can update the table and leave fields intact that don't need to be updated. You need to check the values of the variables for the insert query, and if no value is in the variable, leave the field out of the query completely (unless it is supposed to be NULL). If the field is listed, and there is no value, it will be inserted with no value.