Array inside an array PHP SQL

Answer 1

You want this out side your loop:

$days = array();

And this inside your while loop:

$days[$Myday] = array('/index.php?day=$Myday&year=$MYyear','linked-day');

Your loop isn't actually adding to your array its just assigning a bunch of variables that get rewritten anyways.