gizma
-
Joined: 29 Sep 2003
Posts: 1
|
 Posted: Wed Nov 23, 2005 1:26 am Post subject: Multiple mysql queries - ERROR 500 |
 |
|
I have the latest Abyss, PHP, MySql and phpMyAdmin, all working fine.
When I do a simple loop to insert rows into a MySql table i get an ERROR 500
is this because i've got too many INSERTS?
simplified, it goes something like this...
| Code: |
for($i = 1 ; $i < 1500 ; $i++){
$sqlArtists = "INSERT INTO mytable (id,artist) VALUES ('0','dummy name');";
$result = mysql_query($sqlArtists,$conn);
}
|
how could i go about improving this, as i need to make other queries according to results from this query in the same loop.. so can't use multiple "INSERT INTO mytable ('0','dummy name 1'),('0','dummy name 2')..etc.."
what is good practice for large amounts of inserts? |
|
