Page 1 of 1

insert data for different people on separate rows in Access

Posted: Thu Apr 12, 2007 10:47 am
by davanderbilt
I am still relatively new to all the intricacies of PHP and am having a problem.

I have 10 different students (S1-S10) from the same school who all are given the same foods for lunch on a particular date.

They each get the same entree, condiment (like ketchup), grain, fruit, veggie1, veggie2, beverage1 and beverage2.

I need to be able to enter the amount of each item consumed (like 8 tater tots for the grain) and proportion consumed (i.e. None, 25%, 50%, 100%, other, etc.) for each student. The proportion consumed can be a drop down but it needs to allow you to type in a value if over 200%.

This data then needs to go into an Access table with each student (S1-S10) as a separate row.

Here are my Access fields in order:
schoolid (number) 1001=Burlington, 1002=CCC, 1003=Maple Woods
date (date/time)
student (number) S1=1, S2=2, S3=3 and so on
veg1 (text)
veg1amtconsumed (text)
veg1proportion (text)
veg2 (text)
veg2amtconsumed (text)
veg2proportion (text)
entree (text)
entreeamtconsumed (text)
entreeproportion (text)
condiment (text)
condimentamtconsumed (text)
condimentproportion (text)
bev1 (text)
bev1amtconsumed (text)
bev1proportion (text)
bev2 (text)
bev2amtconsumed (text)
bev2proportion (text)
grain (text)
grainamtconsumed (text)
grainproportion (text)
fruit (text)
fruitamtconsumed (text)
fruitproportion (text)

I haven't found any way to do this other than making people enter each S1's information individually on the page, then go back and enter S2's and repeat the back and forth process for all 10 students, which is a pain. Can anyone help me out with this?

Posted: Fri Apr 13, 2007 8:47 am
by davanderbilt
feyd | Please use

Code: Select all

,

Code: Select all

and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]


This doesn't give an error code, but it doesn't go into the database either.  I know  that the odbc call is correct.  I have the html form and the php insert on different pages.

[b]Here's the form:[/b]
[syntax="html"]
<form name="lunch" action="lunch_add_multiple.php" method="post">
<script type="text/javascript" language="JavaScript"><!-- --></script>
<title>Lunch Consumption Form</title>

  <b><u>Lunch Consumption Monitoring Form</u></b>
  <table width="88%" border="0">
    <tr>
      <td nowrap bordercolor="#000000"><div align="center" class="style1">
          <p align="justify" class="style8">
           DATES must be in this Format: (01/01/07)<BR>
           --------------------------------------------</p>
          
          <p align="justify"><strong>School: </strong>
            <select name="schoolid">
                <option value="1001">Burlington</option>
                <option value="1002">CCC</option>
                <option value="1003">Maple Woods</option>
            </select>
          </strong>
          &nbsp;&nbsp;&nbsp;&nbsp;<strong>Date:</strong>
            <input name="date" type="text" id="date" size="10" maxlength="8">
          </p>
          <p align="justify"><strong>Entree: </strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            <input name="entree" type="text" id="entree" size="40" maxlength="50">
            &nbsp;&nbsp;&nbsp;&nbsp;<strong>Condiment:</strong>&nbsp;
            <input name="condiment" type="text" id="condiment" size="40" maxlength="50">
          </p>
          <p align="justify"><strong>Grain: </strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            <input name="grain" type="text" id="grain" size="40" maxlength="50">
            &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<strong>Fruit:</strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            <input name="fruit" type="text" id="fruit" size="40" maxlength="50">
          </p>
          <p align="justify"><strong>Vegetable 1: </strong>
            <input name="veg1" type="text" id="veg1" size="40" maxlength="50">
            &nbsp;&nbsp;&nbsp;&nbsp;<strong>Vegetable 2:</strong>
            <input name="veg2" type="text" id="veg2" size="40" maxlength="50">
          </p>
          <p align="justify"><strong>Beverage 1: </strong>
            <input name="bev1" type="text" id="bev1" size="40" maxlength="50">
            &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<strong>Beverage 2:</strong>
            <input name="bev2" type="text" id="bev2" size="40" maxlength="50">
          </p>
          <br>
          <table width="100%">
        	<tr>
        		<td width="10%"><b>Student</b></td>
        		<td width="20%">&nbsp;</td>
        		<td width="45%"><b>Amount Consumed</b></td>
        		<td width="35%"><b>Proportion Consumed (in %)</b></td>
        	</tr>
        	<tr>
          		<td align="left">
          		<select name='student[]' size='10' multiple>
                <option value='1'>S1</option>
                <option value='2'>S2</option>
                <option value='3'>S3</option>
                <option value='4'>S4</option>
                <option value='5'>S5</option>
                <option value='6'>S6</option>
                <option value='7'>S7</option>
                <option value='8'>S8</option>
                <option value='9'>S9</option>
                <option value='1-'>S10</option>
            </select>
            	<td align="left">Entree</td>
            	<td><input name="entreeamtconsumed" type="text" id="entreeamtconsumed" size="40" maxlength="50"></td>
            	<td><input name="entreeproportion" type="text" id="entreeproportion" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Fruit</td>
            	<td><input name="fruitamtconsumed" type="text" id="fruitamtconsumed" size="40" maxlength="50"></td>
            	<td><input name="fruitproportion" type="text" id="fruitproportion" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Vegetable 1</td>
            	<td><input name="veg1amtconsumed" type="text" id="veg1amtconsumed" size="40" maxlength="50"></td>
            	<td><input name="veg1proportion" type="text" id="veg1proportion" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Vegetable 2</td>
            	<td><input name="veg2amtconsumed" type="text" id="veg2amtconsumed" size="40" maxlength="50"></td>
            	<td><input name="veg2proportion" type="text" id="veg2proportion" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Grain</td>
            	<td><input name="grainamtconsumed" type="text" id="grainamtconsumed" size="40" maxlength="50"></td>
            	<td><input name="grainproportion" type="text" id="grainproportion" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Condiment</td>
            	<td><input name="condimentamtconsumed" type="text" id="condimentamtconsumed" size="40" maxlength="50"></td>
            	<td><input name="condimentproportion" type="text" id="condimentproportion" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Beverage 1</td>
            	<td><input name="bev1amtconsumed" type="text" id="bev1amtconsumed" size="40" maxlength="50"></td>
            	<td><input name="bev1proportion" type="text" id="bev1proportion" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Beverage 2</td>
            	<td><input name="bev2amtconsumed" type="text" id="bev2amtconsumed" size="40" maxlength="50"></td>
            	<td><input name="bev2proportion" type="text" id="bev2proportion" size="2" maxlength="3"></td>
            </tr>
          </table>
		  <!--<p align="justify">&nbsp;</p>
          <p align="right">ENTER
            <input name="enter" type="text" id="enter" size="10" maxlength="5">
          </p>
          <p align="right">REVIEWED
            <input name="reviewed" type="text" id="reviewed" size="10" maxlength="5">
          </p>-->
          <p align="justify">
            <input type = "hidden" name = "action_h" value = "save">
			<input type = "hidden" name = "user_id" value = "<?php echo $user_id ?>">
          
            <input name="submit" type = "submit" class="style13" value="SUBMIT">
		  </p>
          <p align="justify">&nbsp;</p>
      </div>
	  </td>
    </tr>
  </table>
  <p>&nbsp;</p>
</form>
And here's the lunch_add_multiple.php it references to add into the database:[/syntax]

Code: Select all

<?php
echo '<br><table><tr><td><b>';
foreach ($HTTP_POST_VARS as $key => $value) {
$temp = stripslashes($value);
$HTTP_POST_VARS[$key] = $temp;
}
echo '</td></tr></table></b>';

$schoolid=isset($HTTP_POST_VARS['schoolid']) ? $HTTP_POST_VARS['schoolid'] :'NA';
$date=isset($HTTP_POST_VARS['date']) ? $HTTP_POST_VARS['date'] :'00/00/0000';
//$student=isset($HTTP_POST_VARS['student']) ? $HTTP_POST_VARS['student'] :'NA';
$veg1=isset($HTTP_POST_VARS['veg1']) ? $HTTP_POST_VARS['veg1'] : 0;
$veg1amtconsumed=isset($HTTP_POST_VARS['veg1amtconsumed']) ? $HTTP_POST_VARS['veg1amtconsumed'] : 0;
$veg1proportion=isset($HTTP_POST_VARS['veg1proportion']) ? $HTTP_POST_VARS['veg1proportion'] : 0;
$veg2=isset($HTTP_POST_VARS['veg2']) ? $HTTP_POST_VARS['veg2'] : 0;
$veg2amtconsumed=isset($HTTP_POST_VARS['veg2amtconsumed']) ? $HTTP_POST_VARS['veg2amtconsumed'] : 0;
$veg2proportion=isset($HTTP_POST_VARS['veg2proportion']) ? $HTTP_POST_VARS['veg2proportion'] : 0;
$entree=isset($HTTP_POST_VARS['entree']) ? $HTTP_POST_VARS['entree'] : 0;
$entreeamtconsumed=isset($HTTP_POST_VARS['entreeamtconsumed']) ? $HTTP_POST_VARS['entreeamtconsumed'] : 0;
$entreeproportion=isset($HTTP_POST_VARS['entreeproportion']) ? $HTTP_POST_VARS['entreeproportion'] : 0;
$condiment=isset($HTTP_POST_VARS['condiment']) ? $HTTP_POST_VARS['condiment'] : 0;
$condimentamtconsumed=isset($HTTP_POST_VARS['condimentamtconsumed']) ? $HTTP_POST_VARS['condimentamtconsumed'] : 0;
$condimentproportion=isset($HTTP_POST_VARS['condimentproportion']) ? $HTTP_POST_VARS['condimentproportion'] : 0;
$bev1=isset($HTTP_POST_VARS['bev1']) ? $HTTP_POST_VARS['bev1'] : 0;
$bev1amtconsumed=isset($HTTP_POST_VARS['bev1amtconsumed']) ? $HTTP_POST_VARS['bev1amtconsumed'] : 0;
$bev1proportion=isset($HTTP_POST_VARS['bev1proportion']) ? $HTTP_POST_VARS['bev1proportion'] : 'NA';
$bev2=isset($HTTP_POST_VARS['bev2']) ? $HTTP_POST_VARS['bev2'] : 0;
$bev2amtconsumed=isset($HTTP_POST_VARS['bev2amtconsumed']) ? $HTTP_POST_VARS['bev2amtconsumed'] : 0;
$bev2proportion=isset($HTTP_POST_VARS['bev2proportion']) ? $HTTP_POST_VARS['bev2proportion'] : 'NA';
$grain=isset($HTTP_POST_VARS['grain']) ? $HTTP_POST_VARS['grain'] : 0;
$grainamtconsumed=isset($HTTP_POST_VARS['grainamtconsumed']) ? $HTTP_POST_VARS['grainamtconsumed'] : 0;
$grainproportion=isset($HTTP_POST_VARS['grainproportion']) ? $HTTP_POST_VARS['grainproportion'] : 'NA';
$fruit=isset($HTTP_POST_VARS['fruit']) ? $HTTP_POST_VARS['fruit'] : 0;
$fruitamtconsumed=isset($HTTP_POST_VARS['fruitamtconsumed']) ? $HTTP_POST_VARS['fruitamtconsumed'] : 'NA';
$fruitproportion=isset($HTTP_POST_VARS['fruitproportion']) ? $HTTP_POST_VARS['fruitproportion'] : 'NA';

$conn = odbc_connect("YKIDS","","");

if (isset($_POST['student'])) {
	foreach ($_POST['student'] as $student) {
$insert_statement = "
	insert into 
		lunch_consumption 
		values ($schoolid, '$date', $student, '$veg1', '$veg1amtconsumed', '$veg1proportion', '$veg2', '$veg2amtconsumed', '$veg2proportion', '$entree', '$entreeamtconsumed', '$entreeproportion', '$condiment', '$condimentamtconsumed', '$condimentproportion', '$bev1', '$bev1amtconsumed', '$bev1proportion', '$bev2', '$bev2amtconsumed', '$bev2proportion', '$grain', '$grainamtconsumed', '$grainproportion', '$fruit', '$fruitamtconsumed', '$fruitproportion')";
	
//echo $insert_statement;
//if($error_rep==0)
//{
$result = odbc_exec($conn,$insert_statement);
if(!$result) echo odbc_errormsg();
}
}
?>
There are 10 students data to enter, and I'd like to be able to enter them all on the same form and have each student go in to the database on a separate row. They each get the same entree, condiment (like ketchup), grain, fruit, veggie1, veggie2, beverage1 and beverage2...but each student has a different amount consumed (like 8 tater tots for the grain) and proportion consumed.


feyd | Please use

Code: Select all

,

Code: Select all

and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]

Posted: Fri Apr 13, 2007 12:45 pm
by Begby
You might want to heed this advice


1. In your checks and sets above, isset() only checks if the variable is set to some value, not if the value is blank. So if someone submits a form this this page with all of those named inputs, no 'NA' or 0 will get set even if the form field was left blank or filled with spaces.

2. You aren't escaping any of the data you are putting in the query leaving yourself open for sql injection

3. Try putting your query one more than one line, it makes it pretty hard to debug later on, let alone read, when you have a query with 30 parameters that is 4 pages wide. (you got close on this one, but your query is still not easily maintainable)


This is the second time I posted the above for you, but perhaps you will actually read it this time.


As for your insert problem, you should probably list the fields like this, also note how its formatted and readable

Code: Select all

INSERT INTO table (
 fieldname1,
 fieldname2
)
VALUES(
 val1,
 val2
)
To insert multiple items you can name your HTML form fields something like student[1][schoolID], student[2][schoolID] etc. then for the other info something like student[1][bev1], student[2][bev1] etc.

One PHP side of things you can look trhough student as it will be passed as an array

Code: Select all

$student = $_POST['student'] ;

// Uncomment the following to look at the array and make sure all your form fields are named correctly
// echo '<pre>' ;
// print_r($student)  ;
// echo '</pre> ' ;

foreach($student as $num => $vals)
{
 $bev1 = $vals['bev1'] ;
 $schoolID = $vals['schoolID'] ;
 // and so on and so forth

 // Also do your query here
}

Posted: Fri Apr 13, 2007 2:28 pm
by davanderbilt
Like this for the form?

Code: Select all

<form name="lunch" action="lunch_add_multiple2.php" method="post">
<script type="text/javascript" language="JavaScript"><!--
				function name_fun()
				{
				 $val=document.lunch.FName.options[document.lunch.FName.selectedIndex].value;
				  $a = $val.split("  ");
				   document.lunch.Name1.value=$a[0];
				   document.lunch.Name2.value=$a[1];
				   
				}
				
			  --></script>
<title>Lunch Consumption Form</title>

  <b><u>Lunch Consumption Monitoring Form</u></b>
  <table width="88%" border="0">
    <tr>
      <td nowrap bordercolor="#000000"><div align="center" class="style1">
          <p align="justify" class="style8">
           DATES must be in this Format: (01/01/07)<BR>
           --------------------------------------------</p>
          
          <p align="justify"><strong>School: </strong>
            <select name="schoolid">
                <option value="1001">Burlington</option>
                <option value="1002">CCC</option>
                <option value="1003">Maple Woods</option>
            </select>
          </strong>
          &nbsp;&nbsp;&nbsp;&nbsp;<strong>Date:</strong>
            <input name="date" type="text" id="date" size="10" maxlength="8">
          </p>
          <p align="justify"><strong>Entree: </strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            <input name="entree" type="text" id="entree" size="40" maxlength="50">
            &nbsp;&nbsp;&nbsp;&nbsp;<strong>Condiment:</strong>&nbsp;
            <input name="condiment" type="text" id="condiment" size="40" maxlength="50">
          </p>
          <p align="justify"><strong>Grain: </strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            <input name="grain" type="text" id="grain" size="40" maxlength="50">
            &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<strong>Fruit:</strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            <input name="fruit" type="text" id="fruit" size="40" maxlength="50">
          </p>
          <p align="justify"><strong>Vegetable 1: </strong>
            <input name="veg1" type="text" id="veg1" size="40" maxlength="50">
            &nbsp;&nbsp;&nbsp;&nbsp;<strong>Vegetable 2:</strong>
            <input name="veg2" type="text" id="veg2" size="40" maxlength="50">
          </p>
          <p align="justify"><strong>Beverage 1: </strong>
            <input name="bev1" type="text" id="bev1" size="40" maxlength="50">
            &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<strong>Beverage 2:</strong>
            <input name="bev2" type="text" id="bev2" size="40" maxlength="50">
          </p>
          <br>
          <table width="100%">
        	<tr>
        		<td width="10%"><b>Student</b></td>
        		<td width="20%">&nbsp;</td>
        		<td width="45%"><b>Amount Consumed</b></td>
        		<td width="35%"><b>Proportion Consumed (in %)</b></td>
        	</tr>
        	<tr>
          		<td align="left">
          		<select name="student">
                <option value="1">S1</option>
                <option value="2">S2</option>
                <option value="3">S3</option>
                <option value="4">S4</option>
                <option value="5">S5</option>
                <option value="6">S6</option>
                <option value="7">S7</option>
                <option value="8">S8</option>
                <option value="9">S9</option>
                <option value="10">S10</option>
            </select>
            	<td align="left">Entree</td>
            	<td><input name="student[1][entreeamtconsumed]" type="text" id="student[1][entreeamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[1][entreeproportion]" type="text" id="student[1][entreeproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Fruit</td>
            	<td><input name="student[1][fruitamtconsumed]" type="text" id="student[1][fruitamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[1][fruitproportion]" type="text" id="student[1][fruitproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Vegetable 1</td>
            	<td><input name="student[1][veg1amtconsumed]" type="text" id="student[1][veg1amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[1][veg1proportion]" type="text" id="student[1][veg1proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Vegetable 2</td>
            	<td><input name="student[1][veg2amtconsumed]" type="text" id="student[1][veg2amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[1][veg2proportion]" type="text" id="student[1][veg2proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Grain</td>
            	<td><input name="student[1][grainamtconsumed]" type="text" id="student[1][grainamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[1][grainproportion]" type="text" id="student[1][grainproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Condiment</td>
            	<td><input name="student[1][condimentamtconsumed]" type="text" id="student[1][condimentamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[1][condimentproportion]" type="text" id="student[1][condimentproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Beverage 1</td>
            	<td><input name="student[1][bev1amtconsumed]" type="text" id="student[1][bev1amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[1][bev1proportion]" type="text" id="student[1][bev1proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Beverage 2</td>
            	<td><input name="student[1][bev2amtconsumed]" type="text" id="student[1][bev2amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[1][bev2proportion]" type="text" id="student[1][bev2proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td align="left">
          		<select name="student">
                <option value="1">S1</option>
                <option value="2">S2</option>
                <option value="3">S3</option>
                <option value="4">S4</option>
                <option value="5">S5</option>
                <option value="6">S6</option>
                <option value="7">S7</option>
                <option value="8">S8</option>
                <option value="9">S9</option>
                <option value="10">S10</option>
            </select>
            	<td align="left">Entree</td>
            	<td><input name="student[2][entreeamtconsumed]" type="text" id="student[2][entreeamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[2][entreeproportion]" type="text" id="student[2][entreeproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Fruit</td>
            	<td><input name="student[2][fruitamtconsumed]" type="text" id="student[2][fruitamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[2][fruitproportion]" type="text" id="student[2][fruitproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Vegetable 1</td>
            	<td><input name="student[2][veg1amtconsumed]" type="text" id="student[2][veg1amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[2][veg1proportion]" type="text" id="student[2][veg1proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Vegetable 2</td>
            	<td><input name="student[2][veg2amtconsumed]" type="text" id="student[2][veg2amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[2][veg2proportion]" type="text" id="student[2][veg2proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Grain</td>
            	<td><input name="student[2][grainamtconsumed]" type="text" id="student[2][grainamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[2][grainproportion]" type="text" id="student[2][grainproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Condiment</td>
            	<td><input name="student[2][condimentamtconsumed]" type="text" id="student[2][condimentamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[2][condimentproportion]" type="text" id="student[2][condimentproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Beverage 1</td>
            	<td><input name="student[2][bev1amtconsumed]" type="text" id="student[2][bev1amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[2][bev1proportion]" type="text" id="student[2][bev1proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Beverage 2</td>
            	<td><input name="student[2][bev2amtconsumed]" type="text" id="student[2][bev2amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[2][bev2proportion]" type="text" id="student[2][bev2proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td align="left">
          		<select name="student">
                <option value="1">S1</option>
                <option value="2">S2</option>
                <option value="3">S3</option>
                <option value="4">S4</option>
                <option value="5">S5</option>
                <option value="6">S6</option>
                <option value="7">S7</option>
                <option value="8">S8</option>
                <option value="9">S9</option>
                <option value="10">S10</option>
            </select>
            	<td align="left">Entree</td>
            	<td><input name="student[3][entreeamtconsumed]" type="text" id="student[3][entreeamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[3][entreeproportion]" type="text" id="student[3][entreeproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Fruit</td>
            	<td><input name="student[3][fruitamtconsumed]" type="text" id="student[3][fruitamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[3][fruitproportion]" type="text" id="student[3][fruitproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Vegetable 1</td>
            	<td><input name="student[3][veg1amtconsumed]" type="text" id="student[3][veg1amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[3][veg1proportion]" type="text" id="student[3][veg1proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Vegetable 2</td>
            	<td><input name="student[3][veg2amtconsumed]" type="text" id="student[3][veg2amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[3][veg2proportion]" type="text" id="student[3][veg2proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Grain</td>
            	<td><input name="student[3][grainamtconsumed]" type="text" id="student[3][grainamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[3][grainproportion]" type="text" id="student[3][grainproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Condiment</td>
            	<td><input name="student[3][condimentamtconsumed]" type="text" id="student[3][condimentamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[3][condimentproportion]" type="text" id="student[3][condimentproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Beverage 1</td>
            	<td><input name="student[3][bev1amtconsumed]" type="text" id="student[3][bev1amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[3][bev1proportion]" type="text" id="student[3][bev1proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Beverage 2</td>
            	<td><input name="student[3][bev2amtconsumed]" type="text" id="student[3][bev2amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[3][bev2proportion]" type="text" id="student[3][bev2proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td align="left">
          		<select name="student">
                <option value="1">S1</option>
                <option value="2">S2</option>
                <option value="3">S3</option>
                <option value="4">S4</option>
                <option value="5">S5</option>
                <option value="6">S6</option>
                <option value="7">S7</option>
                <option value="8">S8</option>
                <option value="9">S9</option>
                <option value="10">S10</option>
            </select>
            	<td align="left">Entree</td>
            	<td><input name="student[4][entreeamtconsumed]" type="text" id="student[4][entreeamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[4][entreeproportion]" type="text" id="student[4][entreeproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Fruit</td>
            	<td><input name="student[4][fruitamtconsumed]" type="text" id="student[4][fruitamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[4][fruitproportion]" type="text" id="student[4][fruitproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Vegetable 1</td>
            	<td><input name="student[4][veg1amtconsumed]" type="text" id="student[4][veg1amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[4][veg1proportion]" type="text" id="student[4][veg1proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Vegetable 2</td>
            	<td><input name="student[4][veg2amtconsumed]" type="text" id="student[4][veg2amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[4][veg2proportion]" type="text" id="student[4][veg2proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Grain</td>
            	<td><input name="student[4][grainamtconsumed]" type="text" id="student[4][grainamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[4][grainproportion]" type="text" id="student[4][grainproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Condiment</td>
            	<td><input name="student[4][condimentamtconsumed]" type="text" id="student[4][condimentamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[4][condimentproportion]" type="text" id="student[4][condimentproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Beverage 1</td>
            	<td><input name="student[4][bev1amtconsumed]" type="text" id="student[4][bev1amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[4][bev1proportion]" type="text" id="student[4][bev1proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Beverage 2</td>
            	<td><input name="student[4][bev2amtconsumed]" type="text" id="student[4][bev2amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[4][bev2proportion]" type="text" id="student[4][bev2proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td align="left">
          		<select name="student">
                <option value="1">S1</option>
                <option value="2">S2</option>
                <option value="3">S3</option>
                <option value="4">S4</option>
                <option value="5">S5</option>
                <option value="6">S6</option>
                <option value="7">S7</option>
                <option value="8">S8</option>
                <option value="9">S9</option>
                <option value="10">S10</option>
            </select>
            	<td align="left">Entree</td>
            	<td><input name="student[5][entreeamtconsumed]" type="text" id="student[5][entreeamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[5][entreeproportion]" type="text" id="student[5][entreeproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Fruit</td>
            	<td><input name="student[5][fruitamtconsumed]" type="text" id="student[5][fruitamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[5][fruitproportion]" type="text" id="student[5][fruitproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Vegetable 1</td>
            	<td><input name="student[5][veg1amtconsumed]" type="text" id="student[5][veg1amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[5][veg1proportion]" type="text" id="student[5][veg1proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Vegetable 2</td>
            	<td><input name="student[5][veg2amtconsumed]" type="text" id="student[5][veg2amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[5][veg2proportion]" type="text" id="student[5][veg2proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Grain</td>
            	<td><input name="student[5][grainamtconsumed]" type="text" id="student[5][grainamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[5][grainproportion]" type="text" id="student[5][grainproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Condiment</td>
            	<td><input name="student[5][condimentamtconsumed]" type="text" id="student[5][condimentamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[5][condimentproportion]" type="text" id="student[5][condimentproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Beverage 1</td>
            	<td><input name="student[5][bev1amtconsumed]" type="text" id="student[5][bev1amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[5][bev1proportion]" type="text" id="student[5][bev1proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Beverage 2</td>
            	<td><input name="student[5][bev2amtconsumed]" type="text" id="student[5][bev2amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[5][bev2proportion]" type="text" id="student[5][bev2proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td align="left">
          		<select name="student">
                <option value="1">S1</option>
                <option value="2">S2</option>
                <option value="3">S3</option>
                <option value="4">S4</option>
                <option value="5">S5</option>
                <option value="6">S6</option>
                <option value="7">S7</option>
                <option value="8">S8</option>
                <option value="9">S9</option>
                <option value="10">S10</option>
            </select>
            	<td align="left">Entree</td>
            	<td><input name="student[6][entreeamtconsumed]" type="text" id="student[6][entreeamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[6][entreeproportion]" type="text" id="student[6][entreeproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Fruit</td>
            	<td><input name="student[6][fruitamtconsumed]" type="text" id="student[6][fruitamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[6][fruitproportion]" type="text" id="student[6][fruitproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Vegetable 1</td>
            	<td><input name="student[6][veg1amtconsumed]" type="text" id="student[6][veg1amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[6][veg1proportion]" type="text" id="student[6][veg1proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Vegetable 2</td>
            	<td><input name="student[6][veg2amtconsumed]" type="text" id="student[6][veg2amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[6][veg2proportion]" type="text" id="student[6][veg2proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Grain</td>
            	<td><input name="student[6][grainamtconsumed]" type="text" id="student[6][grainamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[6][grainproportion]" type="text" id="student[6][grainproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Condiment</td>
            	<td><input name="student[6][condimentamtconsumed]" type="text" id="student[6][condimentamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[6][condimentproportion]" type="text" id="student[6][condimentproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Beverage 1</td>
            	<td><input name="student[6][bev1amtconsumed]" type="text" id="student[6][bev1amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[6][bev1proportion]" type="text" id="student[6][bev1proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Beverage 2</td>
            	<td><input name="student[6][bev2amtconsumed]" type="text" id="student[6][bev2amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[6][bev2proportion]" type="text" id="student[6][bev2proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td align="left">
          		<select name="student">
                <option value="1">S1</option>
                <option value="2">S2</option>
                <option value="3">S3</option>
                <option value="4">S4</option>
                <option value="5">S5</option>
                <option value="6">S6</option>
                <option value="7">S7</option>
                <option value="8">S8</option>
                <option value="9">S9</option>
                <option value="10">S10</option>
            </select>
            	<td align="left">Entree</td>
            	<td><input name="student[7][entreeamtconsumed]" type="text" id="student[7][entreeamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[7][entreeproportion]" type="text" id="student[7][entreeproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Fruit</td>
            	<td><input name="student[7][fruitamtconsumed]" type="text" id="student[7][fruitamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[7][fruitproportion]" type="text" id="student[7][fruitproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Vegetable 1</td>
            	<td><input name="student[7][veg1amtconsumed]" type="text" id="student[7][veg1amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[7][veg1proportion]" type="text" id="student[7][veg1proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Vegetable 2</td>
            	<td><input name="student[7][veg2amtconsumed]" type="text" id="student[7][veg2amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[7][veg2proportion]" type="text" id="student[7][veg2proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Grain</td>
            	<td><input name="student[7][grainamtconsumed]" type="text" id="student[7][grainamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[7][grainproportion]" type="text" id="student[7][grainproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Condiment</td>
            	<td><input name="student[7][condimentamtconsumed]" type="text" id="student[7][condimentamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[7][condimentproportion]" type="text" id="student[7][condimentproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Beverage 1</td>
            	<td><input name="student[7][bev1amtconsumed]" type="text" id="student[7][bev1amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[7][bev1proportion]" type="text" id="student[7][bev1proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Beverage 2</td>
            	<td><input name="student[7][bev2amtconsumed]" type="text" id="student[7][bev2amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[7][bev2proportion]" type="text" id="student[7][bev2proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td align="left">
          		<select name="student">
                <option value="1">S1</option>
                <option value="2">S2</option>
                <option value="3">S3</option>
                <option value="4">S4</option>
                <option value="5">S5</option>
                <option value="6">S6</option>
                <option value="7">S7</option>
                <option value="8">S8</option>
                <option value="9">S9</option>
                <option value="10">S10</option>
            </select>
            	<td align="left">Entree</td>
            	<td><input name="student[8][entreeamtconsumed]" type="text" id="student[8][entreeamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[8][entreeproportion]" type="text" id="student[8][entreeproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Fruit</td>
            	<td><input name="student[8][fruitamtconsumed]" type="text" id="student[8][fruitamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[8][fruitproportion]" type="text" id="student[8][fruitproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Vegetable 1</td>
            	<td><input name="student[8][veg1amtconsumed]" type="text" id="student[8][veg1amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[8][veg1proportion]" type="text" id="student[8][veg1proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Vegetable 2</td>
            	<td><input name="student[8][veg2amtconsumed]" type="text" id="student[8][veg2amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[8][veg2proportion]" type="text" id="student[8][veg2proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Grain</td>
            	<td><input name="student[8][grainamtconsumed]" type="text" id="student[8][grainamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[8][grainproportion]" type="text" id="student[8][grainproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Condiment</td>
            	<td><input name="student[8][condimentamtconsumed]" type="text" id="student[8][condimentamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[8][condimentproportion]" type="text" id="student[8][condimentproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Beverage 1</td>
            	<td><input name="student[8][bev1amtconsumed]" type="text" id="student[8][bev1amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[8][bev1proportion]" type="text" id="student[8][bev1proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Beverage 2</td>
            	<td><input name="student[8][bev2amtconsumed]" type="text" id="student[8][bev2amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[8][bev2proportion]" type="text" id="student[8][bev2proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td align="left">
          		<select name="student">
                <option value="1">S1</option>
                <option value="2">S2</option>
                <option value="3">S3</option>
                <option value="4">S4</option>
                <option value="5">S5</option>
                <option value="6">S6</option>
                <option value="7">S7</option>
                <option value="8">S8</option>
                <option value="9">S9</option>
                <option value="10">S10</option>
            </select>
            	<td align="left">Entree</td>
            	<td><input name="student[9][entreeamtconsumed]" type="text" id="student[9][entreeamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[9][entreeproportion]" type="text" id="student[9][entreeproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Fruit</td>
            	<td><input name="student[9][fruitamtconsumed]" type="text" id="student[9][fruitamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[9][fruitproportion]" type="text" id="student[9][fruitproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Vegetable 1</td>
            	<td><input name="student[9][veg1amtconsumed]" type="text" id="student[9][veg1amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[9][veg1proportion]" type="text" id="student[9][veg1proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Vegetable 2</td>
            	<td><input name="student[9][veg2amtconsumed]" type="text" id="student[9][veg2amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[9][veg2proportion]" type="text" id="student[9][veg2proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Grain</td>
            	<td><input name="student[9][grainamtconsumed]" type="text" id="student[9][grainamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[9][grainproportion]" type="text" id="student[9][grainproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Condiment</td>
            	<td><input name="student[9][condimentamtconsumed]" type="text" id="student[9][condimentamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[9][condimentproportion]" type="text" id="student[9][condimentproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Beverage 1</td>
            	<td><input name="student[9][bev1amtconsumed]" type="text" id="student[9][bev1amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[9][bev1proportion]" type="text" id="student[9][bev1proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Beverage 2</td>
            	<td><input name="student[9][bev2amtconsumed]" type="text" id="student[9][bev2amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[9][bev2proportion]" type="text" id="student[9][bev2proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td align="left">
          		<select name="student">
                <option value="1">S1</option>
                <option value="2">S2</option>
                <option value="3">S3</option>
                <option value="4">S4</option>
                <option value="5">S5</option>
                <option value="6">S6</option>
                <option value="7">S7</option>
                <option value="8">S8</option>
                <option value="9">S9</option>
                <option value="10">S10</option>
            </select>
            	<td align="left">Entree</td>
            	<td><input name="student[10][entreeamtconsumed]" type="text" id="student[10][entreeamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[10][entreeproportion]" type="text" id="student[10][entreeproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Fruit</td>
            	<td><input name="student[10][fruitamtconsumed]" type="text" id="student[10][fruitamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[10][fruitproportion]" type="text" id="student[10][fruitproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Vegetable 1</td>
            	<td><input name="student[10][veg1amtconsumed]" type="text" id="student[10][veg1amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[10][veg1proportion]" type="text" id="student[10][veg1proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Vegetable 2</td>
            	<td><input name="student[10][veg2amtconsumed]" type="text" id="student[10][veg2amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[10][veg2proportion]" type="text" id="student[10][veg2proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Grain</td>
            	<td><input name="student[10][grainamtconsumed]" type="text" id="student[10][grainamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[10][grainproportion]" type="text" id="student[10][grainproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Condiment</td>
            	<td><input name="student[10][condimentamtconsumed]" type="text" id="student[10][condimentamtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[10][condimentproportion]" type="text" id="student[10][condimentproportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Beverage 1</td>
            	<td><input name="student[10][bev1amtconsumed]" type="text" id="student[10][bev1amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[10][bev1proportion]" type="text" id="student[10][bev1proportion]" size="2" maxlength="3"></td>
            </tr>
            <tr>
          		<td>&nbsp;</td>
            	<td align="left">Beverage 2</td>
            	<td><input name="student[10][bev2amtconsumed]" type="text" id="student[10][bev2amtconsumed]" size="40" maxlength="50"></td>
            	<td><input name="student[10][bev2proportion]" type="text" id="student[10][bev2proportion]" size="2" maxlength="3"></td>
            </tr>
          </table>
		  <!--<p align="justify">&nbsp;</p>
          <p align="right">ENTER
            <input name="enter" type="text" id="enter" size="10" maxlength="5">
          </p>
          <p align="right">REVIEWED
            <input name="reviewed" type="text" id="reviewed" size="10" maxlength="5">
          </p>-->
          <p align="justify">
            <input type = "hidden" name = "action_h" value = "save">
			<input type = "hidden" name = "user_id" value = "<?php echo $user_id ?>">
          
            <input name="submit" type = "submit" class="style13" value="SUBMIT">
		  </p>
          <p align="justify">&nbsp;</p>
      </div>
	  </td>
    </tr>
  </table>
  <p>&nbsp;</p>
</form>
And lunch_add_multiple2.php?

Code: Select all

<?php
echo '<br><table><tr><td><b>';

//look at the array and make sure all the form fields are named correctly
// echo '<pre>' ;
// print_r($student)  ;
// echo '</pre> 

$student=$_POST['student']

foreach($student as $num => $vals)
{
$schoolid=$_POST['schoolid'];
$date=$vals['date'];
$veg1=$vals['veg1'];
$veg1amtconsumed=$vals['veg1amtconsumed'];
$veg1proportion=$vals['veg1proportion'];
$veg2=$vals['veg2'];
$veg2amtconsumed=$vals['veg2amtconsumed'];
$veg2proportion=$vals['veg2proportion'];
$entree=$vals['entree'];
$entreeamtconsumed=$vals['entreeamtconsumed'];
$entreeproportion=$vals['entreeproportion'];
$condiment=$vals['condiment'];
$condimentamtconsumed=$vals['condimentamtconsumed'];
$condimentproportion=$vals['condimentproportion'];
$bev1=$vals['bev1'];
$bev1amtconsumed=$vals['bev1amtconsumed'];
$bev1proportion=$vals['bev1proportion'];
$bev2=$vals['bev2'];
$bev2amtconsumed=$vals['bev2amtconsumed'];
$bev2proportion=$vals['bev2proportion'];
$grain=$vals['grain'];
$grainamtconsumed=$vals['grainamtconsumed'];
$grainproportion=$vals['grainproportion'];
$fruit=$vals['fruit'];
$fruitamtconsumed=$vals['fruitamtconsumed'];
$fruitproportion=$vals['fruitproportion'];

$conn = odbc_connect("YKIDS","","");

$insert_statement = "
	insert into lunch_consumption (
	schoolid, 
	date, 
	student, 
	veg1, veg1amtconsumed, veg1proportion, 
	veg2, veg2amtconsumed, veg2proportion, 
	entree, entreeamtconsumed, entreeproportion, 
	condiment, condimentamtconsumed, condimentproportion, 
	bev1, bev1amtconsumed, bev1proportion, 
	bev2, bev2amtconsumed, bev2proportion, 
	grain, grainamtconsumed, grainproportion, 
	fruit, fruitamtconsumed, fruitproportion
	) 
	values (
	$schoolid, 
	'$date', 
	$student, 
	'$veg1', '$veg1amtconsumed', '$veg1proportion', 
	'$veg2', '$veg2amtconsumed', '$veg2proportion', 
	'$entree', '$entreeamtconsumed', '$entreeproportion', 
	'$condiment', '$condimentamtconsumed', '$condimentproportion', 
	'$bev1', '$bev1amtconsumed', '$bev1proportion', 
	'$bev2', '$bev2amtconsumed', '$bev2proportion', 
	'$grain', '$grainamtconsumed', '$grainproportion', 
	'$fruit', '$fruitamtconsumed', '$fruitproportion'
	)";
	
//echo $insert_statement;
//if($error_rep==0)
//{
$result = odbc_exec($conn,$insert_statement);
//if(!$result)
//{
//  echo 'There has been ERROR submitting your data. Please go back and check your data.'; 

} 
?>
I wasn't exactly sure what you meant by naming variables like student[1][bev1]. Also, how do escape the data/close the connection?