SQL query help
 

Hi,
Can some one help me with a sql query:

[SQL]$SQL = "SELECT * FROM " .TABLE_PREFIX ."imgtools";[/SQL]

That query works fine and goes on to a while statement listing all the userid's in the table ("imgtools") :)
But I would also like the query to get the actual usernames for each userid.
Any help would be much appreciated I?m at a loss of how to do it with out a query for every userid.

Many Thanks
Mat

Once again thanks,
Is there any chance the same query could get information from the usergroup table?
I want to create $musername containing the right usergroups html open and close tab.

Many Thanks
Mat