RE: mass insert statement

This message was sent from: Development
http://forums.oscommerce.com/viewtopic.php?p=171141#171141
----------------------------------------------------------------

dont worry I have fixed it. Your only supposed to have multiple value sections. So its supposed to read 

$x="";
for... 
... 
$x .= ", (.....) " 
next 
--remove leading comma
$x =  "INSERT INTO ... VALUES" . substr($x, 1) ;
tep_db_query($x); 

ie look like this
$qstring = "INSERT INTO mytable VALUES (NULL,'aaaname', 'simons'), (NULL,'aaaname', 'simons'), (NULL,'aaaname', 'simons');"; 

cheers for the help 
Si.