MySQL Update语句没有';无法使用图像库


MySQL Update statement doesn't work Image Gallery

我有一个名为images_users的表,在这个表中我有


1个img_uploader,
2个img_name,
3个img_id,
4个img_type,
5个img_size,
>6个img_upload_date,
17个img_description
8个img_new_name
9个img_modification

在上传阶段,我将信息插入1/2/3/4/5/6
所以现在在修改页面上,我根本无法更改我尝试过的任何值,但没有任何更改

$req = $BDD->prepare('UPDATE images_users SET 
                                                    img_name =:NEW_img_name, 
                                                    img_id   =:NEW_img_id,, 
                                                    img_new_name =:NEW_img_new_name,
                                                    img_description =:NEW_img_description,
                                                    img_modification = NOW()
                                                    WHERE img_uploader =:username
                                ');
            $req->execute(array(        
                                        'NEW_img_name'         =>   $nom_image_old, 
                                        'NEW_img_id'           =>   $shuffled,
                                        'NEW_img_new_name'     =>   $nom_image_new,
                                        'NEW_img_description'  =>   '',
                                        'username'             =>   $_SESSION['username'],
                                ));

那么问题在哪里呢????

img_id =:NEW_img_id,, 的更新语句中有一个额外的逗号

尝试:

$req = $BDD->prepare('UPDATE images_users SET 
                                                img_name =:NEW_img_name, 
                                                img_id   =:NEW_img_id,  
                                                img_new_name =:NEW_img_new_name,
                                                img_description =:NEW_img_description,
                                                img_modification = NOW()
                                                WHERE img_uploader =:username
                            ');