AC FITTINGS
$username="root";
$database="RESPOND";
$localhost="192.168.1.5";
mysql_connect($localhost,$username,'');
@mysql_select_db($database) or die( "Unable to select database");
$result = mysql_query("SELECT * FROM rparts")
or die(mysql_error());
$rok=0;
while($row = mysql_fetch_array( $result )) {
$rok=$rok+1;
$ref = $row['ref'];
$dnet = $row['dnet'];
if ($ref == "b07"){
$batab07= $dnet;
}elseif ($ref == "b22"){
$batab22= $dnet;
}elseif ($ref == "b27c"){
$batab27c= $dnet;
}elseif ($ref == "ba27"){
$bataba27= $dnet;
}elseif ($ref == "ba26"){
$bataba26= $dnet;
}elseif ($ref == "b2c"){
$batab2c= $dnet;
}elseif ($ref == "b03"){
$batab03= $dnet;
}elseif ($ref == "b05"){
$batab05= $dnet;
}elseif ($ref == "ba05"){
$bataba05= $dnet;
}elseif ($ref == "ba07"){
$batab07= $dnet;
}elseif ($ref == "b02"){
$batab02= $dnet;
}elseif ($ref == "b04"){
$batab04= $dnet;
}elseif ($ref == "ba1010"){
$batab1010= $dnet;
}elseif ($ref == "ba1212"){
$batab1212= $dnet;
}elseif ($ref == "ba102"){
$batab102= $dnet;
}elseif ($ref == "ba103"){
$batab103= $dnet;
}elseif ($ref == "ba104"){
$batab104= $dnet;
}elseif ($ref == "ba631"){
$batab631= $dnet;
}elseif ($ref == "b12"){
$batab12= $dnet;
}elseif ($ref == "ba6"){
$bataba6= $dnet;
}elseif ($ref == "b88"){
$batab88= $dnet;
}elseif ($ref == "ban3"){
$batan3= $dnet;
}elseif ($ref == "ban9"){
$batan9= $dnet;
}elseif ($ref == "ban10"){
$batan10= $dnet;
}elseif ($ref == "ban8"){
$batan8= $dnet;
}elseif ($ref == "s102"){
$batan102= $dnet;
}elseif ($ref == "s101"){
$batan101= $dnet;
}elseif ($ref == "s10e"){
$batan10e= $dnet;
}elseif ($ref == "b51"){
$batab51= $dnet;
}elseif ($ref == "b52"){
$batab52= $dnet;
}elseif ($ref == "bxc"){
$batabxc= $dnet;
}elseif ($ref == "pfc"){
$batapfc= $dnet;
}elseif ($ref == "bfx"){
$batabfx= $dnet;
}elseif ($ref == "bpx"){
$batabpx= $dnet;
}
}
echo "";
echo ' | ';
echo ' | ';
echo ' | ';
echo ' | ';
echo ' | ';
echo "Price $batab07 |
Price $batab22 |
Price $batab27c |
Price $bataba27 |
Price $bataba26 | ";
echo " | ";
echo " | ";
echo " | ";
echo " | ";
echo " | ";
echo '
';
echo "";
echo ' | ';
echo ' | ';
echo ' | ';
echo ' | ';
echo ' | ';
echo "Price $batab03 |
Price $batab05 |
Price $bataba05 |
Price $batab07 |
Price $batab02 | ";
echo " | ";
echo " | ";
echo " | ";
echo " | ";
echo " | ";
echo '
';
echo "";
echo ' | ';
echo ' | ';
echo ' | ';
echo ' | ';
echo ' | ';
echo "Price $batab04 | ";
echo "Price $batab102 | ";
echo "Price $batab103 | ";
echo "Price $batab104 | ";
echo "Price $batab631 | ";
echo " | ";
echo " | ";
echo " | ";
echo " | ";
echo " | ";
echo '
';
echo "";
echo ' | ';
echo ' | ';
echo ' | ';
echo ' | ';
echo ' | ';
echo ' | ';
echo ' | ';
echo "Price $batab1010 | ";
echo "Price $batab12 | ";
echo "Price $batab1212 | ";
echo "Price $bataba6 | ";
echo "Price $batab88 | ";
echo " | ";
echo " | ";
echo " | ";
echo " | ";
echo " | ";
echo '
';
echo "";
echo ' | ';
echo ' | ';
echo ' | ';
echo ' | ';
echo ' | ';
echo ' | ';
echo ' | ';
echo "Price $batan3 | ";
echo "Price $batan9 | ";
echo "Price $batan10 | ";
echo "Price $batan8 | ";
echo "Price $batan102 | ";
echo "Price $batan101 | ";
//echo "Price $batan102 | ";
echo "Price $batan10e | ";
echo '
';
echo '
';
//echo "";
//echo "";
?>