Adding Data to a MultiDimensional Array...

Hey Pertti--thank you so much for your response...I'm trying to wrap my brain around this...

Ok, so when i make the transition from Car Id's to get the Years my sql will look something like this(keeping it simple)

$sql= $this->db->query(" SELECT y.CarID, y.Year FROM Years y WHERE y.CarID = ????$CarID????")

How do I do the variable for CarID in the sql query?