AC COILS
$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 == "b21"){
$batab21= $dnet;
}elseif ($ref == "b27"){
$batab27= $dnet;
}elseif ($ref == "b44"){
$batab44= $dnet;
}elseif ($ref == "b82"){
$batab82= $dnet;
}elseif ($ref == "b8g"){
$batab8g= $dnet;
}elseif ($ref == "b2c"){
$batab2c= $dnet;
}elseif ($ref == "b3c"){
$batab3c= $dnet;
}elseif ($ref == "b5c"){
$batab5c= $dnet;
}elseif ($ref == "bsc"){
$batabsc= $dnet;
}elseif ($ref == "fa02"){
$batf02= $dnet;
}elseif ($ref == "ba73"){
$bata73= $dnet;
}elseif ($ref == "ba30"){
$bata30= $dnet;
}elseif ($ref == "b20"){
$bata20= $dnet;
}elseif ($ref == "b6"){
$batab6= $dnet;
}elseif ($ref == "ba31"){
$bata31= $dnet;
}elseif ($ref == "b2c"){
$batab1c= $dnet;
}elseif ($ref == "b1c"){
$batab1c= $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 "Price $batab2c |
Price $batab1c |
Price $batab51 | ";
//Price $batab8g | ";
echo " | ";
echo " | ";
echo " | ";
echo '
';
echo "";
echo ' | ';
echo ' | ';
echo ' | ';
echo ' | ';
echo "Price $batab52 |
Price $batabxc |
Price $batapfc |
Price $batabfx | ";
//
echo ' | ';
echo "Price $batabpx | ";
echo '
';
echo '
';
echo "";
?>