getting php code to do as i wish
Posted: Mon Jan 12, 2009 3:34 am
im trying to figure out when a form is filled out each set of players gets the same gameno although if another form was to be submitted the gameno would be unique
if theres a tutorial please send link thx
for example
form1
PLAYER - SEX - GAMENO
player1 - male - 1
player2 - female - 1
player3 - male - 1
player4 - female - 1
form2
PLAYER - SEX - GAMENO
player1 - male - 2
player2 - female - 2
player3 - male - 2
player4 - female - 2
heres the code im working on,
if theres a tutorial please send link thx
for example
form1
PLAYER - SEX - GAMENO
player1 - male - 1
player2 - female - 1
player3 - male - 1
player4 - female - 1
form2
PLAYER - SEX - GAMENO
player1 - male - 2
player2 - female - 2
player3 - male - 2
player4 - female - 2
heres the code im working on,
Code: Select all
<?php
function create_game($playername0, $sex0, $playername1, $sex1, $playername2, $sex2, $playername3, $sex3, $playername4, $sex4, $playername5, $sex5, $playername6, $sex6, $playername7, $sex7, $playername8, $sex8, $playername9, $sex9, $playername10, $sex10, $playername11, $sex11, $playername12, $sex12, $playername13, $sex13, $playername14, $sex14, $finalscore)
{
// store the information in the database
$query = "INSERT INTO `game` (`name`, `sex`, `finalscore`) values ('$playername0','$sex0','$finalscore')";
$result = mysql_query($query) or die(mysql_error());
$query = "INSERT INTO `game` (`name`, `sex`, `finalscore`) values ('$playername1','$sex1','$finalscore')";
$result = mysql_query($query) or die(mysql_error());
$query = "INSERT INTO `game` (`name`, `sex`, `finalscore`) values ('$playername2','$sex2','$finalscore')";
$result = mysql_query($query) or die(mysql_error());
$query = "INSERT INTO `game` (`name`, `sex`, `finalscore`) values ('$playername3','$sex3','$finalscore')";
$result = mysql_query($query) or die(mysql_error());
$query = "INSERT INTO `game` (`name`, `sex`, `finalscore`) values ('$playername4','$sex4','$finalscore')";
$result = mysql_query($query) or die(mysql_error());
$query = "INSERT INTO `game` (`name`, `sex`, `finalscore`) values ('$playername5','$sex5','$finalscore')";
$result = mysql_query($query) or die(mysql_error());
$query = "INSERT INTO `game` (`name`, `sex`, `finalscore`) values ('$playername6','$sex6','$finalscore')";
$result = mysql_query($query) or die(mysql_error());
$query = "INSERT INTO `game` (`name`, `sex`, `finalscore`) values ('$playername7','$sex7','$finalscore')";
$result = mysql_query($query) or die(mysql_error());
$query = "INSERT INTO `game` (`name`, `sex`, `finalscore`) values ('$playername8','$sex8','$finalscore')";
$result = mysql_query($query) or die(mysql_error());
$query = "INSERT INTO `game` (`name`, `sex`, `finalscore`) values ('$playername9','$sex9','$finalscore')";
$result = mysql_query($query) or die(mysql_error());
$query = "INSERT INTO `game` (`name`, `sex`, `finalscore`) values ('$playername10','$sex10','$finalscore')";
$result = mysql_query($query) or die(mysql_error());
$query = "INSERT INTO `game` (`name`, `sex`, `finalscore`) values ('$playername11','$sex11','$finalscore')";
$result = mysql_query($query) or die(mysql_error());
$query = "INSERT INTO `game` (`name`, `sex`, `finalscore`) values ('$playername12','$sex12','$finalscore')";
$result = mysql_query($query) or die(mysql_error());
$query = "INSERT INTO `game` (`name`, `sex`, `finalscore`) values ('$playername13','$sex13','$finalscore')";
$result = mysql_query($query) or die(mysql_error());
$query = "INSERT INTO `game` (`name`, `sex`, `finalscore`) values ('$playername14','$sex14','$finalscore')";
$result = mysql_query($query) or die(mysql_error());
// if suceesfully inserted data into database, send confirmation link to email
if($result)
{
header('Location: [url=http://www.pinkangel4u.com/truthdare/Game/gameboard.php');]http://www.pinkangel4u.com/truthdare/Game/...oard.php');[/url]
}
}
?>