[SOLVED] Column 'offense' in field list is ambiguous - ?

[MasterACE14]

hi,

 

I'm having trouble with a MySQL query. I keep receiving this error:

Column 'offense' in field list is ambiguous

 

I have no idea what I have to do to fix this problem.

 

here's my code:

<?php
$sql = "UPDATE `Army` INNER JOIN `UserInfo` ON `UserInfo`.`id` = `Army`.`id` SET `offense` = `offense` + '$amount', `awakened` = `awakened` - '$amount', `UserInfo`.`magi_ava` = (`UserInfo`.`magi_ava` * 1) - '$price' WHERE `UserInfo`.`id` = '$id'";
mysql_query($sql) or die("Cannnot Buy Attack Soldier<br>" . mysql_error());

 

Any help is greatly appreciated.

 

Regards ACE

[bothwell]

I think SQL wants you to specify which table offense belongs to in the join. Try:

 

$sql = "UPDATE `Army` INNER JOIN `UserInfo` ON `UserInfo`.`id` = `Army`.`id` SET `offense` = `Army`.`offense` +

 

?

[MasterACE14]

still no good  :-\

[vikramjeet.singla]

try this...

 

$sql = "UPDATE `Army` INNER JOIN `UserInfo` ON `UserInfo`.`id` = `Army`.`id` SET `Army`.`offense` = `Army`.`offense` + '$amount', `awakened` = `awakened` - '$amount', `UserInfo`.`magi_ava` = (`UserInfo`.`magi_ava` * 1) - '$price' WHERE `UserInfo`.`id` = '$id'";

[MasterACE14]

That fixed it. Thankyou!