Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 02 Sep 2005, 01:57
Nutz's Avatar
Nutz Nutz is offline
 
Join Date: Aug 2004
Real name: Mathew Summerfield
SQL query help

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


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


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
Reply With Quote
  #2  
Old 02 Sep 2005, 02:01
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Real name: Andreas

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Reply With Quote
  #3  
Old 03 Sep 2005, 02:01
Nutz's Avatar
Nutz Nutz is offline
 
Join Date: Aug 2004
Real name: Mathew Summerfield
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
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 20:38.

Layout Options | Width: Wide Color: