Competition Script

totalservers · 03-03-2004, 03:56 AM

I am looking to do the following....

Someone sends a contest entry via SMS and the result is posted to a html page using the following parameters:

source Mobile number of the iTAGG user making the request
dest Destination number (typically the iTAGG shortcode of 83248)
dtime The timestamp of when the request was made
message The entire SMS content of the incoming iTAGG request
network The network ID of the mobile number owner*
????: NamePros.com http://www.namepros.com/programming/22421-competition-script.html

What I need is for this information to be submitted from the HTML page to a mySQL database.

Also at the end of the contest I need to be able to select a winner at random

If anyone can help me out please post here or PM me...

tempest1 · 03-07-2004, 08:05 PM

Create a MySQL table like so...

Code:

Create table contest (
id int not null primary key auto_increment,
source int, 
dest int,
dtime date,
message varchar(255),
netword id varchar(16)
);

And then to randomize the winner use this...
????: NamePros.com http://www.namepros.com/showthread.php?t=22421

PHP Code:

  mysql_connect('','','');

$result = mysq_query('Select * from contest');

$rows = mysql_num_rows($result);

mysql_free_result($result);

$rand = rand(1, $rows);

$result = mysql_query("Select * from contents where id =$rand");

$winner = mysql_fetch_assoc($result);

echo print_r($winner);

mysql_close();

If you need further assistance send me a PM.

Anthony · 03-10-2004, 05:56 PM

Wow, I'm impressed with that answer! I might try that out for a project I'm working on.

totalservers, if we could see this in action on your site, that would be great! Thanks.

totalservers · 03-11-2004, 12:26 AM

tempest1 - thanks for your response.
anthony - as if yet we are yet to implement it - this should be done in the next 3 -5 days.

thx

Anthony · 03-14-2004, 11:10 PM

Quote:

Originally posted by totalservers
tempest1 - thanks for your response.
anthony - as if yet we are yet to implement it - this should be done in the next 3 -5 days.
????: NamePros.com http://www.namepros.com/showthread.php?t=22421

thx

Okay great. Let me know when you have it working

03-03-2004, 03:56 AM	THREAD STARTER #1 (permalink)
totalservers NamePros Member Join Date: Nov 2003 Location: UK Posts: 53	Competition Script I am looking to do the following.... Someone sends a contest entry via SMS and the result is posted to a html page using the following parameters: source Mobile number of the iTAGG user making the request dest Destination number (typically the iTAGG shortcode of 83248) dtime The timestamp of when the request was made message The entire SMS content of the incoming iTAGG request network The network ID of the mobile number owner* ????: NamePros.com http://www.namepros.com/programming/22421-competition-script.html What I need is for this information to be submitted from the HTML page to a mySQL database. Also at the end of the contest I need to be able to select a winner at random If anyone can help me out please post here or PM me... __________________ UniTunes Community Forums - Register Now & hear about our offers, freebies and new features First! New Competition Coming Soon!

03-07-2004, 08:05 PM	#2 (permalink)
tempest1 New Member Join Date: Mar 2004 Posts: 2	Create a MySQL table like so... Code: Create table contest ( id int not null primary key auto_increment, source int, dest int, dtime date, message varchar(255), netword id varchar(16) ); And then to randomize the winner use this... ????: NamePros.com http://www.namepros.com/showthread.php?t=22421 PHP Code: `mysql_connect('','',''); $result = mysq_query('Select * from contest'); $rows = mysql_num_rows($result); mysql_free_result($result); $rand = rand(1, $rows); $result = mysql_query("Select * from contents where id =$rand"); $winner = mysql_fetch_assoc($result); echo print_r($winner); mysql_close();` If you need further assistance send me a PM.

03-11-2004, 12:26 AM	THREAD STARTER #4 (permalink)
totalservers NamePros Member Join Date: Nov 2003 Location: UK Posts: 53	tempest1 - thanks for your response. anthony - as if yet we are yet to implement it - this should be done in the next 3 -5 days. thx __________________ UniTunes Community Forums - Register Now & hear about our offers, freebies and new features First! New Competition Coming Soon!

03-10-2004, 05:56 PM	#3 (permalink)
Anthony NamePros Expert Join Date: Dec 2003 Location: NYC Posts: 9,132	Wow, I'm impressed with that answer! I might try that out for a project I'm working on. totalservers, if we could see this in action on your site, that would be great! Thanks.

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