Looping over query

[akus_mail_com]

Hi All,

This is my first post to this forum as I am a php beginner so please be gentle.

My Issue: Tried to loop over an insert query over 1500 times. While loop carries on to 1500, database inserst stop at 1000 (huh).
Can I change this somehow.

A

[lanjoky]

Can you show us the code you used so we can see how you are doing it?? Much appreciated

[akus_mail_com]

heres my code,

with this code ProductIDs stop at 1500

$ProductIDCounter = 500;

while ($ProductIDCounter < 1600) {

$query = "INSERT INTO tblProduct (ProductID,ProductName,ProductDescription) VALUES ($ProductIDCounter,'eka tuote', ' tuoteselostetta sitten on')";
mysql_query ($query)
or die ("Query failed");

//$result = mysql_query ($query)
//or die ("Query failed");

$ProductIDCounter = $ProductIDCounter + 1;

print $ProductIDCounter;
}

[lanjoky]

whats your database (MYSQL, SQL Server) ... and what does this table look like ie field names types and sizes?

thanks

[akus_mail_com]

database: mysql

fields:
ProductID int(11) - is maximum value for this 1000
ProductName varchar(200)
ProductDescription blob

[lanjoky]

Thats why you cant instert above 1000. Your ProductID int(11) - has maximum value for this 1000 there for no more inserts can be made. Make your productID field A Long Int. That should fix the problem, if I am understanding what you say the problem is correctly.

Hope that Helps

[akus_mail_com]

actually there was no problem witht the datatype, it was the query editor (control centre) that i am using. It restricts number of returned rows to 1000. DOU!!!

Thanks anyway

A