Everything is working fine except for one part of the script. I know this because i tested adding each individual item.
Here is the code for the form of the part i'm having problems with:
Code: Select all
<select class="tblack" name="month2">
<? select_month(); ?>
</select> <select class="tblack" name="day2">
<? select_day($day2); ?>
</select> <select class="tblack" name="year2">
<? select_year(); ?>
</select>Code: Select all
<?PHP
(connection info up here)
$sql ="INSERT INTO `results_archives` (sport, date, day, play, stars, w_l_p, win, loss, push, bb_win, bb_loss, bb_push) values ('$_POST[sport]','$_POST[month2]-$_POST[day2]-$_POST[year2]','$_POST[day]','$_POST[play]','$_POST[stars]','$_POST[win_lose_push]','$_POST[win]','$_POST[loss]','$_POST[push]','$_POST[bb_win]','$_POST[bb_loss]','$_POST[bb_push]')";
if (mysql_query($sql,$db_conn)){
echo "records added!";
}else{
echo "something went wrong";
}
?>Code: Select all
'$_POST[month2]-$_POST[day2]-$_POST[year2]'