Re: db insert question

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? Thanks, James 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