amestres Posted October 3, 2008 Posted October 3, 2008 I need to enter the same value for all customers inside a particular field in the customer database. Insted of going customer by customer, opening that field, entering the value, etc (which will take forever), is there a way I can enter the same value in the field for all customers?
♥geoffreywalton Posted October 3, 2008 Posted October 3, 2008 Yes, write an sql update command. Use the sql section of www.w3schools.com to get some good examples. Use phpmyadmin from your ISP's admin area to run the sql statement you develop. Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>.
amestres Posted October 4, 2008 Author Posted October 4, 2008 Great!!!! It took me less than 5 minutes to figure out and do it. thnaks a million
♥geoffreywalton Posted October 4, 2008 Posted October 4, 2008 No problem Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.