I have the following code to insert into mysql db.
i am posting just the code which i have problem.
my $incolor_qry="insert into colorimage_info(pid,color) values
After inserting this i need to update the rows which i inserted by the following code:
my $upcolor_qry="update colorimage_info set color_image='$colo
+r_image.JPG' where id='$newpid';
The results which i am getting is
pid cid color color_image
8000 1 Blue a1.jpg
8000 2 Silver a1.jpg
The color_image column is not updated properly. I am missing some thing here. Can anyone tell me where i am wrong.cid column is autocremented and not null.