Competition Script

[totalservers]

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*

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]

Create a MySQL table like so...

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...

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]

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]

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]

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.

thx

Okay great. Let me know when you have it working