Creating a simple footer navigation menu

On top of what Josh mentioned, the CSS LIst Menu webpart only selects "published" documents. Are your documents using workflow? Are they published?

Regarding a repeater vs. a css list menu, by all means the repeater is way more flexible and it is as easy to use as the list menu. Most cases, the end user won't have any access to the webparts anyway, simply the content, so I wouldn't worry about the webpart you use as long as it does what you want.

Without the where clause, all the root level pages appear just fine. I don't know that I have access to the database..? Is "footer" the db value that's stored for the "footer menu" Menu group that's built into Kentico?

You can find what is stored by looking at the document type for the page(menu item) and going to the fields. On the fields, the field MenuItemGroup will have the values and the first items in the box are the values that are stored.

The values in the field by default are:(value, text) ;{$general.empty$} top;{$menugroup.top$} footer;{$menugroup.footer$} left;{$menugroup.left$}

Does your where clause look like this: MenuItemGroup='footer'

So just make sure that your documents have that footer option selected and see if that fixes anything. Also as Brenden suggested, make sure the documents are published. They must have the green icon, otherwise, the document isn't published and won't show in the list.

Apparently what I have is right. But it's not working with the pages I made yesterday. I added two more pages and set their Menu Group to footer and it works just fine...but not with the old pages... But thank you for your help issue resolved :)