Simple question regarding extraction of mysql value.

[waynew]

I have the following code:

 

//List of distinct months/years : graph timeline from beginning to end.
$time_line_result - mysql_query("SELECT DISTINCT MONTH(reg_date), YEAR(reg_date) FROM jobs WHERE status = 1 ORDER BY reg_date ASC LIMIT 1");

$time_line = array();
$i=0; //Reset to 0 for purpose of incrementing array key
while($month_year_row = mysql_fetch_assoc($time_line_result)){
     
 $time_line[$i] = $month_year_row[???????????

 

You may have seen the question marks above... what exactly am I going to give $time_line[$i]?

[cooldude832]

Any item you want from the return mysql row

you can type

print_r($month_year_row); in the while loop to see the content of the rows