Creating a multidimensional array variab

Anon

Creating a multidimensional array variable from a mysql table

I want to create a variable which is a multidimensional array. I've tried using many combinations of mysql_fetch_array(), mysql_fetch_row(), etc. etc. incorporating them into loops, but have been unsuccessful. I want to create a variable identical to $rushers below from the table that is also listed below. My players table will constantly be growing so $rushers will also have to adjust to the growing table by adding more arrays. Any help would be very much appreciated. If you have any questions please let me know. Thank you.

$rushers = array( array(1, 27, "Ryan Weldin", 5734),
array(2, 20, "Joe Caquelin", 2345),
array(3, 2, "Mark Weisburg", 123));

mysql> select * from players;
+----------+--------+---------------+-------+
| playerid | number | name | yards |
+----------+--------+---------------+-------+
| 1 | 27 | Ryan Weldin | 5734 |
| 2 | 20 | Joe Caquelin | 2345 |
| 3 | 2 | Mark Weisburg | 123 |
+----------+--------+---------------+-------+

Anon

$rushers=array();

$sql="select * from players";

while (go through the $row...) {
$rushers +=array($row('playerid'), $row('number'), $row('name'), $row('yards'));
}

something like that...

techek

You could also do this :

<?php
// get your data from your DB

while($row = mysql_fetch_array()) {
$playerid = $row[playerid];
$number = $row[number];
$name = $row[name];
$yards = $row[yards];

$rushers[$playerid] = array('playerid'=>$playerid, 'number'=>$number, 'name'=>$name, 'yards'=>$yards);
}

reset($rushers);
echo "Playerlist :<br>\n";
while(list($index, $data) = each($rushers)) {
echo "|".$data[playerid]."|".$data[name]."|<br>\n";
}

Phew, I know it looks much more complicated than Craig's example, but I'm also hoping to show a little more what you can do with array's ...

Go have a look at http://www.kobox.dk/tube/random_feature/random.php by the way s

Anon

I couldn't get your link to do much Techek... None of the links or images worked.

one of the differences in our approaches:

mine produces a numerical array and Techek's produces an associative array. Not that either is more or less useful, but they are used in different ways. That's part of the reason why his takes longer.