I have field username with datas like 5101,5102,5103 in a table "cc_dailylog". I have a list box in my jsp page which displays all these usernames. If i select more than 1 username and tried to update a campaign "Aircel" for all the username,i am unable to update. so i tried to split the username with comma and put it in a loop and tried to update the campaign "Aircel" for all the usernames like the following:
when i try to run the code the print statement prints the following and nothing is updated.
update cc_dailylog set campaign='Aircel' where username in(',5101,5102,5103')
When i tried to execute the above directly in phpmyadmin, it also shows error. Then how can i update more than 1 username and update the value "Aircel" for all these usernames.Please assist me to do this.
your query should be like this :
you need to modify your for loop to add single quote.
But the printed query is
update cc_dailylog set campaign='Aircel' where username in (','5101,'5102,'5103');
Where am i wrong?>