Page 1 of 1

can't update!!

Posted: Sun Jan 21, 2007 10:58 am
by hmsg
for some reason i can't update my registers here is my code:

PHP:

Code: Select all

<?
$sql_update = "UPDATE materiais SET
						(cod_material='".$cod_material."', 
						descricao_material='".$descricao_material."',
						preco_compra_material='".$preco_compra_material."', 
						medidas_material='".$medidas_material."')
						WHERE id_material='".$id_material."'";
$resultado = mysql_db_query($database_BD ,$sql_update);
?>
I also try this:

PHP:

Code: Select all

<?
$sql_update = "UPDATE materiais SET
						(cod_material='$cod_material', 
						descricao_material='$descricao_material',
						preco_compra_material='$preco_compra_material', 
						medidas_material='$medidas_material')
						WHERE id_material='$id_material'";
$resultado = mysql_db_query($database_BD ,$sql_update);
?>

Any of this workout!!

What i'm doing wrong?


Sami | please use the

Code: Select all

tag to post code. Thanks![/color][/size]

Posted: Sun Jan 21, 2007 11:28 am
by hmsg
I've already saw what is wrong

the set don't use the ()

:)