mySQL help

Left joins suck

I have a huge headache I am hoping someone can cure by helping me with some code.

I have 2 tables:
user_online
user

user_online only holds user_id
user has user_id and user_name

I need code to grab and list user_name(s) of the user_id(s) that are present in the user_online table

Clear as mud? Thanks for anyone offering any help.

 

Oh, and if you could incorporate, I also need
$num_rows = mysql_num_rows($result);
of only the user_online table
Not sure how to include this in the above needed query if at all possible to save an additional query

 

Are you still looking for help?

 

Nope. Got it worked out. Thanks though!

 

I didn't even see this question, glad you got it worked out though.