foreach insert error

[Haig Davis <level510@xxxxxxxxx>]

Hello All,

I have spent the entire day trying to get my calendar app to function
correctly ---  I have no problem with the actual functioning of the
calendar. What is giving me trouble is for each calendar day the user has
the option to check a checkbox requesting the day off and additionally the
user must select a weighting for the request i.e. 1-31 with 1 being 1st
choice and 31 being their least desirable request. The request is then
insered into a mysql database.

I am relativly new to PHP so I may well be on the complete wrong track here.
so far I have tried imploding the array & posting an associative array.

Form Script:

<div class="workspace">
<?php
if(isset($_POST['submit'])){

    $userID = mysql_real_escape_string(trim($userID));
    $year = mysql_real_escape_string(trim($_GET['year']));
    $month = mysql_real_escape_string(trim($_GET['mon']));
    $dayoff = $_POST['dayoff'];
    $weighting = mysql_real_escape_string(trim($_POST['weight']));
    var_dump($dayoff);

        foreach ($dayoff as
$day){                                                         //come back
to this when figured out that inserting day works to inser wieghting

        $sql = "INSERT INTO dayoff (userID, month, year, day) VALUES
('$userID', '$year', '$month', '$day')";

        $q = mysql_query($sql)
        or die ('error making request');
        }


 }
?>
<div class="form">
<form name="form" method="post" action="<?php $_SERVER['PHP_SELF'] ; ?>">
<h2>Request Day Off</h2><br /><br />
<?php include '../includes/dayoffcalendar.php' ; ?>

<br /><br /><br />
<button type="submit" name="submit" value="Submit"
class="button">Submit</button>
<button type="reset" class="button">Reset</button>
</form>

Calendar Script:


for($i = 1; $i <= $last['mday']; $i++){
   if($i == $today['mday'] && $first['mon'] == $today['mon'] &&
$first['year'] == $today['year']){
      $style = 'today';
   }
   else{
      $style = 'day';
   }
   $filename="$1.['month'].['year']";
   echo '  <div class="' . $style . '">' . $i . '<br /><br />' ; // creates
comment box for points and check box for request day off
   echo '  <label><small>Point Weighting: </small></label><input type="text"
name="weight$i[]" size ="3" maxlength="3" /><Br /><br /> ';
   echo '  <label><small>Check Day Off: </small></label><input type
="checkbox" name="dayoff[]" value="\". $i . \"" /><br /> ';
   echo '  </div>' . "\n";

   }

I appreciate any advice that you may have. Thank you very much in advance,
my head hurts and I've googled for a few hours with no joy.

Thanks

Haig