PHP While loop array type

require("connect.php");
$array = array();
$query = mysql_query("SELECT * FROM `cms_news` LIMIT 3")or die(mysql_error());
while($row = mysql_fetch_assoc($query))
{
    array_push($array, $row['columnNameHere'];
}

This will put all variables with the column name 'columNameHere' in the array.

I'm not very sure if this is what you meant, but I guess I'm close

I think I understand were you are heading - you want each field accesible independently? Create some arrays that corresponds to each field :

$title = array();
$name = array(); 
//..etc

$query = mysql_query("SELECT * FROM `cms_news` LIMIT 3")or die(mysql_error());
while($row = mysql_fetch_assoc($query)) {
    $title[]=$row['title'];
    $name[]=$row['name'];
    //etc, dont know the fieldnames
}

//now you can
echo $title[1];
echo $name[2];

the arrays are zerobased

require("connect.php");
$query = mysql_query("SELECT * FROM `cms_news` LIMIT 3")or die(mysql_error());
$all_rows = array(); //make an empty array
while($row = mysql_fetch_assoc($query))
{
    $all_rows[] = $row; //add the row to the end of my array
}

Now you can look at $all_rows[0] for the first row, $all_rows[1] for the second row and so on. If you are just going to loop through the array to do things however, you should have just done those things in the while loop.