<html>
<head>
<script type="text/JavaScript">
function addRow(r){
var root = r.parentNode;//the root
var allRows = root.getElementsByTagName('tr');//the rows' collection
var cRow = allRows[3].cloneNode(true)//the clone of the 1st row
var cSel = cRow.getElementsByTagName('select');
for(var t=0;t<cSel.length;t++){
cSel[t].setAttribute('name',cSel[t].getAttribute('name')+'_'+(allRows.length+1))};//change the selecet's name
root.appendChild(cRow);//appends the cloned row as a new row
}
</script>
</head>
<?php include("dbinfo.php"); ?>
<form method="post" action = "31.php" name ="roofing">
<form method="post" action = "31.php" >
<table width="350" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
<td>Sexo</td>
<td>Edad</td>
<td>Altura</td>
</tr>
<tr>
<td>Padre</td>
<td>
<select name="sexo_padre">
<option value="0" selected>Select</option>
<option value="1">Hombre</option>
<option value="2">Mujer</option>
</select></td>
<td><?php
$ed = "SELECT * FROM familia WHERE rank_edad = 2";
$eda = mysql_query($ed) or die(mysql_error());
echo "<select name=edad_padre> <option value=''>Elegir</option>";
while($c_edad=mysql_fetch_array($eda)){
echo "<option value=$c_edad[edad]>$c_edad[edad]</option>";
}
echo "</select>";
?>
</td>
<td>
<select name="altura_padre">
<option value="0" selected>Seleccione</option>
<option value="1">Normal a alta</option>
<option value="2">Baja</option>
</select></td>
</tr>
<tr>
<td>Esposa</td>
<td>
<select name="sexo_sp">
<option value="0" selected>Seleccione</option>
<option value="1">Hombre</option>
<option value="2">Mujer</option>
</select></td>
<td><?php
$ed1 = "SELECT * FROM familia WHERE rank_edad = 2";
$eda1 = mysql_query($ed1) or die(mysql_error());
echo "<select name=edad_sp> <option value=''>Seleccione</option>";
while($c_edad1=mysql_fetch_array($eda1)){
echo "<option value=$c_edad1[edad]>$c_edad1[edad]</option>";
}
echo "</select>";
?></td>
<td>
<select name="altura_sp">
<option value="0">Seleccione</option>
<option value="1">Normal a alta</option>
<option value="2">Baja</option>
</select></td>
</tr>
<tr>
<td>Hijo</td>
<td >
<select name="sexo_ch">
<option value="0" selected>Seleccione</option>
<option value="1">Hombre</option>
<option value="2">Mujer</option>
</select></td>
<td ><?php
$ech = "SELECT * FROM familia WHERE rank_edad = 1";
$echi = mysql_query($ech) or die(mysql_error());
echo "<select name=edad_ch> <option value=''>Seleccione</option>";
while($c_edad=mysql_fetch_array($edad)){
echo "<option value=$c_edad[edad]>$c_edad[edad]</option>";
}
echo "</select>";
?></td>
<td >
<select name="altura_ch">
<option value="0" selected>Seleccione</option>
<option value="1">Coef1</option>
<option value="2">Coef2</option>
</select></td>
<td></td>
</tr>
<tr>
<td><input name="button2" type="button" value="Add child" onClick="addRow(this.parentNode.parentNode)"></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
<input name="calc2" type="submit" value="Calculate Cost">
</form>
<p> </p>