2D array in MySQL

[Anon]

Hi,

I'm trying to setup a 2D board (9x9) for a game. I'd like the script to pull the status for each square from my mySQL database.

I cannot however figure out how to put an array in mySQL. Is there a way to do this?

Thanks in advance for your help,
--Chris

[ceejayoz]

Basically, I'd like to be able to use board[x][y] to get the status (stored in the mySQL database) of that particular square.

[Anon]

I would setup a function where it is:

board(int x, int y)
{
Select Status from Board where X_Cord=x AND Y_Cord=y;
}

In Mysql I'd setup a table Called "Board" With types:

Board_ID int
X_Cord int
Y_Cord int
Status int (or whatever)
Insert_Date daytime
Update_Date daytime