Posted by JamesBenson on 07/21/05 16:52

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
>

• Next in forum: RE: [PHP] db insert question
• Prev in forum: Re: [PHP] GET form method and accessing its value into a cookie
• Thread view: Re: [PHP] db insert question

[Reply to this message]