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