[RESOLVED] Update Multiple Fields

[wmhop]

Can't get multiple fields to update. This is the code I was using:

This works for a single field:

$sql2 = "UPDATE active365 SET payment_status= $payment_status WHERE custom = '$custom'";

So does this:

$sql2 = "UPDATE active365 SET active= 'Y' WHERE custom = '$custom'";

But when I try this code for multiple fields it doesn't work also doesn't error:

$sql2 = "UPDATE active365 SET payment_status= $payment_status, active='Y' WHERE custom = '$custom'";

any suggestions?

[devinemke]

$sql2 = "UPDATE active365 SET payment_status = '$payment_status', active = 'Y' WHERE custom = '$custom'";

[wmhop]

Thanks devinemke ,

But that didn't work either. I'll keep trying other variations besides the "hundreds" I've tried already. In the mean time if you come up with anything let me know.

Thanks again.

[devinemke]

have you considered that there might simply be no records matching your WHERE clause? that would explain the lack of error.

[wmhop]

I forgot to mention that the "payment_status" field does update it's just that the "active" field doesn't update. So the Where clause is matched. I can also split the two statement up on two lines and it works I just wanted to do it on one line.

[wmhop]

My apologies. I wasn't paying attention to what I was doing. I was making my changes to the wrong statement. So...

$sql2 = "UPDATE active365 SET payment_status = '$payment_status', active = 'Y' WHERE custom = '$custom'";  

actually does work. Note that I didn't put single quotes around $payment_status

Thanks

oops again kep the single quotes on