LearningKid Posted December 24, 2009 Share Posted December 24, 2009 Hi i was wondering if it is possible to add multible entries to a table, say i have <?php $sql="insert into colours (Color,Name,Value) values ('yes','blue','2')"; ?> if i want to add like yes,no,yes,no,yes,etc then red,white,orange,grey,orange,etc and then 2,3,4,5,6. anyway i can do tht? Quote Link to comment https://forums.phpfreaks.com/topic/186262-multiple-entries-at-once/ Share on other sites More sharing options...
Buddski Posted December 24, 2009 Share Posted December 24, 2009 The answer is yes.. $sql="insert into colours (Color,Name,Value) values ('yes','blue','2'), ('no','red','3'), ('no','green',6)"; and so on.. Quote Link to comment https://forums.phpfreaks.com/topic/186262-multiple-entries-at-once/#findComment-983734 Share on other sites More sharing options...
LearningKid Posted December 24, 2009 Author Share Posted December 24, 2009 Thank You Very Much Quote Link to comment https://forums.phpfreaks.com/topic/186262-multiple-entries-at-once/#findComment-983736 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.