valavanp has asked for the wisdom of the Perl Monks concerning the following question:
Hi monks,
I have the following code to insert into mysql db.
i am posting just the code which i have problem.
After inserting this i need to update the rows which i inserted by the following code:@color=(Blue, Silver); $newpid=8000; foreach $color(@color){ $color=~s/^\s*//g; my $incolor_qry="insert into colorimage_info(pid,color) values + ('$newpid','$color')"; my $incolor_qy=$db->prepare($incolor_qry); $incolor_qy->execute; }
The results which i am getting is@color_image=(a1.jpg, b1.jpg); foreach $color_image(@color_image){ $color_image=~s/^\s*//g; my $upcolor_qry="update colorimage_info set color_image='$colo +r_image.JPG' where id='$newpid'; my $upcolor_qy=$db->prepare($upcolor_qry); $upcolor_qy->execute; }
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.pid cid color color_image 8000 1 Blue a1.jpg 8000 2 Silver a1.jpg
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: sql queries updation improper
by derby (Abbot) on Jul 15, 2007 at 15:30 UTC | |
by Tobin Cataldo (Monk) on Jul 16, 2007 at 13:00 UTC | |
by derby (Abbot) on Jul 16, 2007 at 13:58 UTC | |
by spatterson (Pilgrim) on Jul 17, 2007 at 15:39 UTC | |
Re: sql queries updation improper
by kyle (Abbot) on Jul 16, 2007 at 02:21 UTC | |
Re: sql queries updation improper
by perllove (Beadle) on Jul 15, 2007 at 15:28 UTC | |
Re: sql queries updation improper
by graff (Chancellor) on Jul 16, 2007 at 13:03 UTC |
Back to
Seekers of Perl Wisdom