从mysql加载数组数组

Question

Basically I want to take 4 of the 16 columns; id,username,country,signupdate; in my table and make an array of arrays out of them.

mysql table

I have a basic grasp on the concept, grab a row and place in an array, then the next one, and so on. then put the arrays in an array.

Only one problem. I have absolutely no idea how to do this. I just started learning in php and mysql, so please be patient. Thanks in advance!

Answer 1

It should do that automatically for you:

$query = mysql_query("SELECT `id`,etc");
while( $row = mysql_fetch_assoc( $query ) )
{
  echo $row['id'];
  echo $row['etc'];
}

That will give you each row of your 'associative array'. Or, you can make a big associative array:

$bigArray = array();
$query = mysql_query("SELECT `id`,etc");
while( $row = mysql_fetch_assoc( $query ) )
{
  $bigArray[] = $row;
}

print_r($bigArray);