RE: [PHP] db insert question

Hi You may try sending multiple query with one mysql_query() function call via seperating by ";". Regards. -Cafer Prş, 2005-07-21 tarihinde 10:02 -0400 saatinde, Jim Moseby yazdı: > > > > Jim Moseby wrote: > > >>Im using mysql with PHP4, whats the best way to insert as > > many as 20 > > >>records at one time from a form? > > >> > > >>Currently im just assigning each one a variable but that is > > messy and > > >>takes ages, is their a way to loop over the array of form data then > > >>maybe do the same to enter it into a database? > > >> > > >> > > >>Thanks for any help. > > > > > > > > > A generic question begs a generic answer: > > > > > > foreach($formdata as $thisdata){ > > > $result=mysql_query("insert into ... values($thisdata) > > where ..."); > > > } > > > > > > > > > Hope this helps, but it would be useful to have code > > examples, etc so that a > > > more relevant answer could be rendered. > > > > > > JM > > > > > > > Thanks for your reply, your example demonstrates what i was doing but > > does that do a MySQL query for every piece of data? > > So 20 form values would be 20 db queries, would that not > > consume a lot > > of resources? > > Is their another way? > > > > As far as I know, there is no way to insert 20 unique rows of data into a > MySQL table without executing 20 queries. Maybe someone else here does(?). > Perhaps drop a note over on the MySQL list, since this is really more an SQL > question than PHP. Sorry I couldn't help. > > JM >