Ok, sorta got done with what I could call my first real widget, it looks allows you to give it a list of blog id's and it then lists the most recent post from them.
I currently have it listing 3 blogs and a small sample from each of their most recent posts.
The SQL calls im doing manually, because I dont know how to do it via wordpress, so my database password etc is all hardcoded which is fine if only I want to use it, but I might want to let others use it.
So whats the wordpress method for calling sql queries and getting results. ??