Inserting 100x and 100y coordinates in mysql table - easy way?

[slyte33]

Is there a way to insert this data into a mysql table named 'map' with the fields: 'x int 3' , 'y int 3' in an easy way with maybe a for loop or something?

 

I want the data entered to be like this:

 

0x 0y

1x, 0y

2x,0y

3x,0y

 

 

all the way up to 100x and 100y.

 

All feedback appreciated, thanks

 

[blueman378]

where are you getting your data from?

[trq]

You could, but it might hurt a little.

 

for ($x=0; $x<=100;$x++) {
    for ($y=0;$y<=100;$y++) {
mysql_query("INSERT INTO map(x,y) VALUES ($x,$y);");
    }
}