dlabacs Posted July 14, 2011 Share Posted July 14, 2011 Hi I'm really new to php/mysql. I'm working on a php/mysql school project with 39 fields all in all in a single table. I want to shorten my codes especially on doing sql queries. $sql = "INSERT into mytable ('field_1',...'field_39') Values('{$_POST['textfield_1']}',...'{$_POST['textfield_39']}')"; I don't know how to figure out this but , i want something like: $sql = "Insert into mytable ("----all fields generated via loop/array----") Values("----all form elements genrated via loop/array---")"; Please Help. Quote Link to comment https://forums.phpfreaks.com/topic/241956-need-help-how-to-create-sql-insert-value-fields-in-loop/ Share on other sites More sharing options...
trq Posted July 14, 2011 Share Posted July 14, 2011 implode. Quote Link to comment https://forums.phpfreaks.com/topic/241956-need-help-how-to-create-sql-insert-value-fields-in-loop/#findComment-1242600 Share on other sites More sharing options...
dlabacs Posted July 14, 2011 Author Share Posted July 14, 2011 i don't know how to use implode(). Sorry. Quote Link to comment https://forums.phpfreaks.com/topic/241956-need-help-how-to-create-sql-insert-value-fields-in-loop/#findComment-1242642 Share on other sites More sharing options...
trq Posted July 14, 2011 Share Posted July 14, 2011 That is precisely why I pointed you to the manual page. Quote Link to comment https://forums.phpfreaks.com/topic/241956-need-help-how-to-create-sql-insert-value-fields-in-loop/#findComment-1242654 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.