Skip to Content.
Sympa Menu

en - Sympa & SQL newbie Q

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • From: "Ben-Nes Michael" <address@concealed>
  • To: <address@concealed>
  • Subject: Sympa & SQL newbie Q
  • Date: Sun, 27 Jul 2003 18:50:01 +0200

Hi All

Im eagerly look for mailing list server that can integrated into my web
application.

I mean that the users will subscribe through the Web site directly to the
RDBMS using tables like:

Users Table:
user_id
username
password
email
...
...
...

Users_Hobbies Table:

user_hobbies_id
user_id -> forigen key to Users
Hobbies
...
...

then I want to set list 1 to:
select users.email from users left join users_hobbies USING ( user_id )
where users_hobbies.hobbies = 'cars';

and list 2 will be:

select users.email from users left join users_hobbies USING ( user_id )
where users_hobbies.hobbies = 'cats';


Is it possible using Sympa ?

--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
Fax: 972-4-6990098
http://www.canaan.net.il
--------------------------




Archive powered by MHonArc 2.6.19+.

Top of Page