DropLister

I want to make it so people can enter their email into a table and later an email can be randomly picked from the table as a winner for a free domain name.

Is there a way to display the current amount of emails in the table. Check the table to be sure that the email isnt already present. And pick a name at random?

__________________

axilant

yes there is... :P ill gladly make the code for you for a few np$ :P

mixon

such a commercial world we living in :-)

PMs sent, how it helped, I am going off!

__________________
FOR SALE: infochecker.com/net | tophosting.us | flyeasier.com | gofornews.com
|wantedprice.com | talkspeed.com | organiclcd.com | trade-on-line.com | nexane.com
getprivate.info | getfresh.info | unsaved.info

stscac

yeah droplister, i'll code it for you

-Steve

Peter

to count the email address use count, to make sure you dont get the same emaill address twice in the table use unique for that field when creating the table.

Porte

Or:

let's say you setup the form <input type="text" size="25" name="email_addr">
when the page is submitted, you can check that email doesn't exist:

<?
$email_addr = $_POST['email_addr'];
$sql_emailchk = mysql_query("SELECT * FROM emails WHERE email_addr='$email_addr'");
$sql_result = mysql_num_rows($sql_emailchk);
if ($sql_result > 0) { // this means that email already exists
// show error or some page with error...
} else {
$sql_insert_email = mysql_query("INSERT INTO emails VALUES('', '$email_addr')");
}
?>

That was a basic function, now you make sure that email isn't duplicate of another.
To show total emails in your database, you can use count..and you can use

<?
$sql_getnum = mysql_query("SELECT * FROM emails");
$sql_num = mysql_num_rows($sql_getnum); // this will return number of rows
echo $sql_num; // should be some number...
?>

Well, basically, if you want to get one random result from your database/table, you could use something like RAND(); to randomize a result..
heres a tip:

Just call this function:
function GetRandomWinner() {
$sql_getrandom = mysql_query("SELECT * FROM emails ORDER BY RAND() LIMIT 0, 1");
$row = mysql_fetch_array($sql_getrandom);
extract($row);

echo 'Winning email: ';
echo $email_addr;
}

To call this function inside php, just use <? GetRandomWinner(); ?>

To get more than one winner randomly, increase the LIMIT 0, <b>1</b>

Not a complete code, but I hope it is helpful.

DropLister

thanks designporte that helped alot

__________________