请那位 好心人 帮帮 我这条语句 那里错误啊

$query = "UPDATE`a_xiaoshafen`SET`id`='".$id."',`caidian`='".$caidian."',`riqi`='".$riqi."',`chanlva`='".$chanlva."',`chanlvb`='".$chanlvb."',`chanlvc`='".$chanlvc."',`chanlvd`='".$chanlvd."',`chanlve`='".$chanlve."',`chanlvf`='".$chanlvf."',`huifena`='".$huifena."',`huifenb`='".$huifenb."',`huifenc`='".$huifenc."',`huifend`='".$huifend."',`huifene`='".$huifene."',`huifenf`='".$huifenf."',`lururen`='".$lurenren."',`lurenriqi`='".$lurenriqi."',WHERe id = '".$id."'";

还是错误，不知道怪什么地方
#0:
SQL语句: UPDATE `a_xiaoshafen` SET `id`='',`caidian`='kjhg',`riqi`='2012-10-19',`chanlva`='66',`chanlvb`='56',`chanlvc`='765',`chanlvd`='765',`chanlve`='765',`chanlvf`='75',`huifena`='765',`huifenb`='765',`huifenc`='756',`huifend`='765',`huifene`='765',`huifenf`='7436',`lururen`='',`lurenriqi`='', WHERe id = ''

$lurenriqi."',WHERe id = '".$id."'"; 最后这行 where 前多了个","号.
自己用 echo $query;;看看就知道了。
正确的：
$query = "UPDATE `a_xiaoshafen` SET `id`='".$id."',`caidian`='".$caidian."',`riqi`='".$riqi."',`chanlva`='".$chanlva."',`chanlvb`='".$chanlvb."',`chanlvc`='".$chanlvc."',`chanlvd`='".$chanlvd."',`chanlve`='".$chanlve."',`chanlvf`='".$chanlvf."',`huifena`='".$huifena."',`huifenb`='".$huifenb."',`huifenc`='".$huifenc."',`huifend`='".$huifend."',`huifene`='".$huifene."',`huifenf`='".$huifenf."',`lururen`='".$lurenren."',`lurenriqi`='".$lurenriqi."' WHERe id = '".$id."'";

你好！ 这是什么语言啊？没见过啊 我的回答你还满意吗~~

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息