RE: [PHP] db insert question

From: Date: Thu, 21 Jul 2005 13:42:23 +0000
Subject: RE: [PHP] db insert question
Groups: php.general 
Request: Send a blank email to php-general+get-219118@lists.php.net to get a copy of this message
> > 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

« previous php.general (#219118) next »