Hello All,

I am trying to create a sort of grid.

For example, the following fields would be present in the table:

Location
North
East
South
West

Basically I want a script where i could type in 'B2' (This would be the location field) and after i click submit it would calculate that north was B1, south was B3, east was C2 and west was A2.

would these need to be seperate fields (one field for B and one for 2) or can this be calculated to fit into one field in the mysql database?

Thanks for your help in advance!

Well a far simpler way would be to have X and Y both as integers as then it's +1 and -1 on each. If you specifically wanted it like A1 etc. It wouldn't be difficult to format it so it changes the X to a character instead.

I've never done or seen this in php, but I guess it's possible to just use numbers instead and when printing them, adding a fix number and have the number converted into a ASCII character. All characters have a number in the ASCII table (can't remeber where it starts), so A would be represented by lets say 63. B=64, C=65 and so on. After Z comes a, b, c and so on.

So you could simply have two fields, X and Y coordinate, which are both numbers. A coordinate could then be i.e. (2,5). By adding 63 (again, dont remeber the real number but you can find ASCII tables on the web) you would get (65,68) and by converting them to characters you would get (C,F).

EDIT: And, the point being that is is simpler to find the fileds next to the one selected when representing them with numbers. To find north, add 1 to Y. To find south, substract 1 from Y. East and west would be X+1 and X-1. In the same manner, north east would be (x+1, Y+1).