storing pulled data into individual vars

[Rifts]

Hey everyone

I'm pulling data from my db and then trying to store each value to its own var. the problem is the amount of values is always changing.

 

here is what I have that isnt working

$result = mysql_query("SELECT thismonth FROM list");

while($row = mysql_fetch_array($result))
  {
echo $row[0] . "<br>";  // this prints out all the values perfectly
     
  }
  

 

no I just dont know how to store them so i can use them later.

[Pawn]

$months = array();
while($row = mysql_fetch_assoc($result)) {
    $months[] = $row[0];
}
print_r($months);

[Rifts]

that out puts nothing

[AbraCadaver]

Change mysql_fetch_assoc() to mysq_fetch_array().

[PFMaBiSmAd]

or just use $row['thismonth']

[Pawn]

Sorry, my bad.

 

$months = array();
while($row = mysql_fetch_row($result)) {
    $months[] = $row[0];
}
print_r($months);

Or what PFMaBiSmAd said.