Tile Generation Script?

[GundamSV7]

Hi there,

I'm currently working on a game and in the mysql table, I have fields x and y, which stand for the (x,y) position the user is standing at, I plan for the arena to just be 10x10 so I was wondering if anyone knew of a fast way to generate a 10x10 field into a mysql database without having to enter it in x=1, y=1, and so on manually?

[drawmack]

<?php
//off the cuff code typed into the forum and not tested
//no I will not debug it for you either
for($i=1;$i<11;$i++) {
    for($j=1;$j<11;$j++) {
        $sql = "INSERT INTO <table> (x,y) VALUES ($i,$j)";
        mysql_query($sql);
    } //end for j
} //end for i
?>

[GundamSV7]

cool, thanks, it worked with no problems 🙂