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. 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. 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. 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. 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
Archived
This topic is now archived and is closed to further replies.