Call Username from DB by userID

Hey everyone, I am having trouble getting this to show up for some reason.. I've been able to do it with other things, but I am looking to have a username show up for users that is stored in a database..

Here is my table structure for the username

CREATE TABLE IF NOT EXISTS `cu_username` (
  `usernameId` int(10) NOT NULL auto_increment,
  `usernameUserid` int(30) NOT NULL default '0',
  `usernameTitle` text NOT NULL,
  PRIMARY KEY  (`usernameId`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=82 ;

Code (markup):

When a user signs into the game their userID is stored along with the usernameTitle (this is what I would like displayed)

Any suggestions on how to do this?

I thought it would be something like this (but can't figure out how to make sure the right username comes out with the right ID and the output code)

$res = query("SELECT COUNT(*) FROM `cu_username` WHERE `usernameTitle`!=$user");

Code (markup):

Thanks in advance!
-Bill

 

$res = query("SELECT COUNT(*) FROM `cu_username` WHERE `usernameTitle`!=$user");

You need single quotes around $user.

$res = query("SELECT COUNT(*) FROM `cu_username` WHERE `usernameTitle`!='$user'");

 

ah damn something so simple!! Thank You Very Much

Now to call it all I would have to enter is simply '.$usernameTitle.' correct?