Multidimensional array/SQL question

basil

I have a table that looks something like this:

| | | |

| Member | Statusflag | Turns |

| | | |

| Fred | 1 | 7 |

| | | |

| Bill | 3 | 8 |

My actual table has more rows and columns, but this will do for discussion.

What I want to do is querry the table and pull it into a two-dimensional arrry and then be able to pick out specifis rows/colums. I know if I do this:

$query = "SELECT * FROM VRPLAYERS where ".membernumber." LIKE '%".$membernum."%'";
$result = @mysql_query($query);
$getit = mysql_fetch_array($result);

Then I can get Fred's "Turns" like this

$Fredsturns=$getit["Turns"];

My question is, can I do a querry like:

$query="SELECT * FROM VRPLAYERS";

so I can get the entire table. If so, then how would I access, for example, Bill's Status Flag? Would it just be:

$Billstatus=$getit[1, Statusflag]; ?

(My table didn;t come out quite the way I wanted .. sorry about that

tbach2

AFAIK, you can only get one row at a time. So, just build your array as you iterate through the results.

How you access Bill's turns depends on how you build the array:

$membernumber = $getit['membernumber'];
$players[$membernumber]['status'] = $getit['status'];
$players[$membernumber]['turns'] = $getit['turns'];

etc.

basil

But how would I do the query in MYSQL?
Thanks.

tbach2

just do the query without the WHERE statement as you suggested.

$query="SELECT * FROM VRPLAYERS";

and let me correct my previous post:

$member = $getit['member'];
$players[$member]['status'] = $getit['status'];
$players[$member]['turns'] = $getit['turns'];

assuming that 'member' is the member's name, you would have for example

$member['Fred']['status'] = 1

and

$member['Fred']['turns'] = 7