[insert_php]

$selection=$_POST[‘meal’];

/* Connect to database */
$link = mysql_connect(“localhost”, “nutrition”, “nutritionrox”)
or die(“Could not connect : ” . mysql_error());
//print “Connected successfully”;
mysql_select_db(“nutrition”) or die(“Could not select database”);

for($i = 0; $i count($selection); $i++){ /* Perform SQL query */ $query = “SELECT * FROM item WHERE Item_Name = ‘$selection[$i]’ ”; $result = mysql_query($query) or die(“Query failed : ” . mysql_error()); /* Print results */ while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { $calories = $row[‘Calories’]; $item_name = $row[‘Item_Name’]; $cals_from_fat = $row[‘Cals_From_Fat’]; $serving_size = $row[‘Serving_Size’]; $total_fat = $row[‘Total_Fat’]; $sat_fat = $row[‘Sat_Fat’]; $cholesterol = $row[‘Cholesterol’]; $sodium = $row[‘Sodium’]; $potassium = $row[‘Potassium’]; $carbs = $row[‘Carbs’]; $sugar = $row[‘Sugar’]; $fiber = $row[‘Fiber’]; $protein = $row[‘Protein’]; } $cal_total = $cal_total + $calories; $cals_from_fat_total = $cals_from_fat_total + $cals_from_fat; $total_fat_total = $total_fat_total + $total_fat; $sat_fat_total = $sat_fat_total + $sat_fat; $cholesterol_total = $cholesterol_total + $cholesterol; $sodium_total = $sodium_total + $sodium; $potassium_total = $potassium_total + $potassium; $carbs_total = $carbs_total + $carbs; $sugar_total = $sugar_total + $sugar; $fiber_total = $fiber_total + $fiber; $protein_total = $protein_total + $protein; $percent_total_fat = $total_fat_total / 65; //float round ( float $percent_total_fat [, int $precision = 0 [, int $mode = PHP_ROUND_HALF_UP ]] ); //echo $percent_total_fat; echo ”

“;
echo ”

“;
echo ”

“;
echo ”

“;
echo ”

“;
echo ”

“;
echo ”

“;
echo ”

“;
echo ”

“;
echo ”

“;
echo ”

“;
echo ”

“;
echo ”

“;
echo ”

“;
}

echo ”

“;
echo ”

“;
echo ”

“;
echo ”

“;
echo ”

“;
echo ”

“;
echo ”

“;
echo ”

“;
echo ”

“;
echo ”

“;
echo ”

“;
echo ”

“;
echo ”

“;
echo ”

“;

mysql_free_result($result);

/* Close connection */
mysql_close($link);
[/insert_php]