Search the Community

I have a form that people use to calculate their blood alcohol level. It currently does this with weight, sex and number of drinks. I want to add a multiplier that uses the type of drink to impact the BAC number since some drinks have more alcohol than others. The alcohol is selected in the form from a drop down iist. So far I have created a separate table with a column called Drink and a column called Alcohol_Content. I am getting stuck tying the two queries together . Any help would be appreciated. Thanks! Here is the code I have: <?php require_once ('db-connect.php'); ?> <?php $result = ''; if(isset($_POST['Sex'])){ $sex = mysql_real_escape_string ($_POST['Sex']); $weight = mysql_real_escape_string ($_POST['Weight']); $number = mysql_real_escape_string ($_POST['Number']); $hours = mysql_real_escape_string ($_POST['Hours']) * 0.015; $Drinktype = mysql_real_escape_string( $_POST['Drink'] ); $Alcohol = mysql_real_escape_string( $_POST['Alcohol_Content'] ); $query = "SELECT `".$number."` FROM ".$sex." WHERE body_weight <= '".$weight." lb.' ORDER BY body_weight DESC"; $result = mysql_query($query); $row = mysql_fetch_array($result); $query = "SELECT `".$Alcohol."` FROM ".$Drinktype."; $result = mysql_query($query); $row2 = mysql_fetch_array($result); $result = $row[$number] - $hours * $row2; $result = 'Your Blood Alcohol Level is: '.$result.'%'; } ?>