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? 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.. 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 Link to comment https://forums.phpfreaks.com/topic/186262-multiple-entries-at-once/#findComment-983736 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.