Hi guys/gals,
I'm basically trying to do a DISTINCT select on a table.
The table contains;
ID | Username | SubmittedSiteFrom
Basically, I need to grab a list of UNIQUE usernames from this table. This works;
SELECT DISTINCT(Username) FROM lsql_
UserCreditTrack
However, this only gives access to "Username!", and not "SubmittedSiteFrom". Is there any way to specify that I want to import the SubmittedSiteFrom value too, into the hashref?
I've tried everything I can think of... but nothing will work :(
TIA
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
I'm basically trying to do a DISTINCT select on a table.
The table contains;
ID | Username | SubmittedSiteFrom
Basically, I need to grab a list of UNIQUE usernames from this table. This works;
SELECT DISTINCT(Username) FROM lsql_
UserCreditTrack
However, this only gives access to "Username!", and not "SubmittedSiteFrom". Is there any way to specify that I want to import the SubmittedSiteFrom value too, into the hashref?
I've tried everything I can think of... but nothing will work :(
TIA
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!