2 tables, 1 solution :)
Posted: Mon Dec 30, 2002 11:30 am
I am having major trouble doing something… I have 2 tables
Table 1 “DOMAINS” which has an ID number and the NAME (of the domain)
Table 2 “MAIL” which has MAIL_NAME (the users account name) and DOM_ID (the # referencing the NAME in the DOMAINS table)
What I think I want to do is concat MAILNAME@NAME to form a list of email addresses, make sense?
ANY help appreciated or do i need PHP to do this also (if i cant do it straight from mysql)
Table 1 “DOMAINS” which has an ID number and the NAME (of the domain)
Table 2 “MAIL” which has MAIL_NAME (the users account name) and DOM_ID (the # referencing the NAME in the DOMAINS table)
What I think I want to do is concat MAILNAME@NAME to form a list of email addresses, make sense?
ANY help appreciated or do i need PHP to do this also (if i cant do it straight from mysql)