|
|
$SQL1 = "SELECT * FROM tb_kru where sp_id='$row[id]' ";
$Qurey1 = mysqli_query($con,$SQL1) or die(mysqli_error($con));
$numrows = mysqli_num_rows($Qurey1);
//echo $SQL1; ?>
echo $numrows; ?>
|
$SQL11 = "SELECT * FROM tb_kru where sp_id='$row[id]' and kruType='1' ";
$Qurey11 = mysqli_query($con,$SQL11) or die(mysqli_error($con));
$numrows11 = mysqli_num_rows($Qurey11);
//echo $SQL11;
//echo $numrows11;
?>
echo $numrows11; ?>
|
$SQL12 = "SELECT * FROM tb_kru where sp_id='$row[id]' and kruType='2' ";
$Qurey12 = mysqli_query($con,$SQL12) or die(mysqli_error($con));
$numrows12 = mysqli_num_rows($Qurey12);
//echo $SQL12;
//echo $numrows12;
?>
echo $numrows12; ?>
|
$SQL13 = "SELECT * FROM tb_kru where sp_id='$row[id]' and kruType='3' ";
$Qurey13 = mysqli_query($con,$SQL13) or die(mysqli_error($con));
$numrows13 = mysqli_num_rows($Qurey13);
//echo $SQL13;
//echo $numrows13;
$sumkrue3=$numrows13+$numrows13;
?>
echo $numrows13; ?>
|
} //close $sumkrue=0;
?>
$SQL_sumkru = "SELECT * FROM tb_kru ";
$Qurey_sumkru = mysqli_query($con,$SQL_sumkru) or die(mysqli_error($con));
$sumkru = mysqli_num_rows($Qurey_sumkru);
$SQL_sumkru1 = "SELECT * FROM tb_kru where kruType='1' ";
$Qurey_sumkru1 = mysqli_query($con,$SQL_sumkru1) or die(mysqli_error($con));
$sumkru1 = mysqli_num_rows($Qurey_sumkru1);
$SQL_sumkru2 = "SELECT * FROM tb_kru where kruType='2' ";
$Qurey_sumkru2 = mysqli_query($con,$SQL_sumkru2) or die(mysqli_error($con));
$sumkru2 = mysqli_num_rows($Qurey_sumkru2);
$SQL_sumkru3 = "SELECT * FROM tb_kru where kruType='3' ";
$Qurey_sumkru3 = mysqli_query($con,$SQL_sumkru3) or die(mysqli_error($con));
$sumkru3 = mysqli_num_rows($Qurey_sumkru3);
?>