November 14th, 2000, 04:02 AM
Below is a section of my script, I want it to loop through the select query and insert the results into a temp table that has an incremented id, only what happens is that it only inserts 1 row when there should be over 100; does anybody know why, or can you only insert 1 row at a time hence the insert into statement does not work in a loop.
Any ideas would be most welcome
$sth = $dbh->prepare("select Customer.CustID,
$sth = $dbh->do("INSERT INTO temp1 (Rangeid,SalesPersonnelID,
'$row')") | | die print "problem with the insert query";
$i = $i+1;