[SOLVED] Need Update query Help

[elentz]

I have the code below.  It won't do the update, all I get is a blank page and no update to my table.  I know mu variables $mitax and $formatnet_total is correct since I can echo them to the page.  Where have I mucked this up?

 

$sql4 ="Update vtiger_invoicecf SET 'cf_602' = '$mitax', 'cf_604' = '$formatnet_total' where vtiger_invoicecf.invoice = '$id'";
$result = mysql_query($sql4) or die("Error in Query result");

 

Thanks

[rhodesa]

What is the output of:

$sql4 ="Update vtiger_invoicecf SET 'cf_602' = '$mitax', 'cf_604' = '$formatnet_total' where vtiger_invoicecf.invoice = '$id'";
echo $sql4;

[pocobueno1388]

Try

 

<?php

$sql4 ="Update vtiger_invoicecf SET cf_602 = '$mitax', cf_604 = '$formatnet_total' where invoice = '$id'";
$result = mysql_query($sql4) or die(mysql_error() . "<p>With Query<br>$sql4");

[rhodesa]

Try

 

<?php

$sql4 ="Update vtiger_invoicecf SET cf_602 = '$mitax', cf_604 = '$formatnet_total' where invoice = '$id'";
$result = mysql_query($sql4) or die(mysql_error() . "<p>With Query<br>$sql4");

 

good catch...that will definitely cause problems

[elentz]

You guys are quick!!!!

 

I haven't tried it yet, but what was the "Catch"?

[rhodesa]

single quotes around the field names...there shouldn't be any or you should use backticks => `

[elentz]

in other words a NOOBIE issue   thanks alot guys that got me working.