|
|
Posted by Jim Moseby on 07/21/05 17:02
>
> 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
Navigation:
[Reply to this message]
|