SMS Message and Email Message
 

Hi,

I need to send a SMS message or/and Email in my database project. Which one is better option for me;

Shall i create database with Oracle or MySQL?

Thanks

Re: SMS Message and Email Message
 

You can create database with either of them. Sending an SMS will cost you but email does not. To send SMS, you need a SMS gatewy like clickatell.com.

Re: SMS Message and Email Message
 

Depending on the SMS messages you are sending, it could be free. If you are sending to cell phone carriers you only need to know their CELL NUMBER and the CELL PHONE CARRIER to determine the appropriate SMS e-mail address.

Use this format:
[10-digit phone number]@cell_provider.com

Alltel
[10-digit phone number]@message.alltel.com
Example: 2125551212@message.alltel.com

AT&T Wireless (now part of Cingular)
[10-digit phone number]@mmode.com
Example: 2125551212@mmode.com

Boost Mobile
[10-digit phone number]@myboostmobile.com
Example: 2125551212@myboostmobile.com

Cingular
[10-digit phone number]@mobile.mycingular.com OR
[10-digit number]@cingularme.com
Example: 4152221212@cingularme.com

Nextel (now part of Sprint Nextel)
[10-digit telephone number]@messaging.nextel.com
Example: 7035551234@messaging.nextel.com

Sprint PCS (now Sprint Nextel)
[10-digit phone number]@messaging.sprintpcs.com
Example: 2125551234@messaging.sprintpcs.com

T-Mobile
[10-digit phone number]@tmomail.net
Example: 4251234567@tmomail.net

Verizon
[10-digit phone number]@vtext.com
Example: 5552223333@vtext.com

Virgin Mobile USA
[10-digit phone number]@vmobl.com
Example: 5551234567@vmobl.com

Here is a table for example:

CREATE TABLE `cell_providers` (

  `providerID` mediumint(8) unsigned NOT NULL auto_increment,

  `name` varchar(50) NOT NULL default '',

  PRIMARY KEY  (`providerID`)

) TYPE=MyISAM AUTO_INCREMENT=19 COMMENT='cell providers for fans table' AUTO_INCREMENT=19 ;



-- 

-- Dumping data for table `cell_providers`

-- 



INSERT INTO `cell_providers` (`providerID`, `name`) VALUES (1, 'Only Send Me Email'),

(2, 'Cingular'),

(3, 'Cricket'),

(4, 'Verizon'),

(5, 'Sprint'),

(6, 'T-Mobile US'),

(7, 'T-Mobile UK'),

(8, 'T-Mobile Germany'),

(9, 'Bell Canada'),

(10, 'Rogers Canada'),

(11, 'Telus Canada'),

(12, 'Vodafone UK'),

(13, 'Vodafone Germany'),

(14, 'E-Plus Germany'),

(15, 'Personal Argentina'),

(16, '02 UK'),

(17, 'Orange UK'),

(18, 'Orange France');