Creating simple page with select from db

[kafi]

Here is my first newbie try (never done any php page on my own). Can somebody point me out to some articles or give me hint what should I do to display querry?
I am getting this outcome:

Resource id #49

intead of usernames.

PHP Code:

<?php 

/************************************************************************\
 *
 * test
 *
\************************************************************************/

define('THIS_SCRIPT', 'test');


// ######################## SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);



// Require vBulletin backend
require_once('./global.php');


$navbits = array();
$navbits = construct_navbits($navbits);

    $select = "SELECT user.username FROM user WHERE userid IN (2,3,4)"; 
    $query = mysql_query($select)or die(mysql_error()); 

echo "$query";
?>

Any help appreciated