|
connect();
$sql_result=mysql_query("SELECT alctable_alcmm,alctable_alcvv,alctable_density,alctable_sg2020,alctable_sg2004,alctable_asg FROM alctable WHERE alctable_alcmm BETWEEN '$alcm_min%' AND '$alcm_max%'");
if ($a1) //submited
{
if ($sql_result) //select succesfull and submit
{
if (mysql_num_rows($sql_result) == 0) // nothing found.
{
echo " Nothing found. ";
}
else // will create table only if found.
{
echo "Density and Concentration of Water/Ethanol Solutions ";
echo "Alcohol - from: ";
echo $alcm_min;
echo " (% m/m) to: ";
echo $alcm_max;
echo " (% m/m)
";
echo " ";
echo "";
echo "| Alcohol | Density | SG20/04 | SG20/20 | ASG | ";
echo "| % m/m | % V/V | g/cm-3 | - | - | - | ";
while($z=MySQL_Fetch_Array($sql_result)){
echo "| {$z["alctable_alcmm"]} | {$z["alctable_alcvv"]} | {$z["alctable_density"]} | {$z["alctable_sg2020"]} | {$z["alctable_sg2004"]} | {$z["alctable_asg"]} | ";
}
echo "
| ";
echo " ";
}
} }
$sql_result1=mysql_query("SELECT alctable_alcmm,alctable_alcvv,alctable_density,alctable_sg2020,alctable_sg2004,alctable_asg FROM alctable WHERE alctable_alcvv BETWEEN '$alcv_min%' AND '$alcv_max%'");
if ($a2) //submited
{
if ($sql_result1) //select succesfull and submit
{
if (mysql_num_rows($sql_result1) == 0) // nothing found.
{
echo "Nothing found. ";
}
else // will create table only if found.
{
echo "Density and Concentration of Water/Ethanol Solutions ";
echo "Alcohol - from: ";
echo $alcv_min;
echo " (% V/V) to: ";
echo $alcv_max;
echo " (% V/V)
";
echo " ";
echo "";
echo "| Alcohol | Density | SG20/04 | SG20/20 | ASG | ";
echo "| % m/m | % V/V | g/cm-3 | - | - | - | ";
while($z=MySQL_Fetch_Array($sql_result1)){
echo "| {$z["alctable_alcmm"]} | {$z["alctable_alcvv"]} | {$z["alctable_density"]} | {$z["alctable_sg2020"]} | {$z["alctable_sg2004"]} | {$z["alctable_asg"]} | ";
}
echo "
| ";
echo " ";
}
} }
$sql_result2=mysql_query("SELECT alctable_alcmm,alctable_alcvv,alctable_density,alctable_sg2020,alctable_sg2004,alctable_asg FROM alctable WHERE alctable_density BETWEEN '$dens_max%' AND '$dens_min%'");
if ($a3) //submited
{
if ($sql_result2) //select succesfull and submit
{
if (mysql_num_rows($sql_result2) == 0) // nothing found.
{
echo "Nothing found. ";
}
else // will create table only if found.
{
echo "Density and Concentration of Water/Ethanol Solutions ";
echo "Density - from: ";
echo $dens_min;
echo " (g/cm-3) to: ";
echo $dens_max;
echo " (g/cm-3)
";
echo " ";
echo "";
echo "| Alcohol | Density | SG20/04 | SG20/20 | ASG | ";
echo "| % m/m | % V/V | g/cm-3 | - | - | - | ";
while($z=MySQL_Fetch_Array($sql_result2)){
echo "| {$z["alctable_alcmm"]} | {$z["alctable_alcvv"]} | {$z["alctable_density"]} | {$z["alctable_sg2020"]} | {$z["alctable_sg2004"]} | {$z["alctable_asg"]} | ";
}
echo "
| ";
echo " ";
}
} }
?>
|