使用php的MySql多重查询的建议(Advice on MySql multi query using php)

 让我从这开始..我从来没有使用.php脚本进行编程，而且对编程还比较陌生，我正在开发一个以Android Studio IDE为中心的新项目，我通常使用JAVA编写。 我一直在尝试使用下面这个.php脚本，我一直在用我需要的修改。 它运作良好，但是，我很难找出如何做一个多重查询，基本上我正在寻找我的'回声'线，但如果有多个匹配到FSC / NIIN领域，那么它应该显示我额外的比赛。 
 
 返回历史记录，列出了一些FSC / NIIN字段中的多个零件号，我正努力让它显示与库存号（FSC / NIIN）相匹配的附加零件号。 任何帮助或建议非常感谢！ 
 
<?php 
require "conn.php";
$FSC = $_POST["FSC"];
$NIIN = $_POST["NIIN"];
$mysql_qry = "select * from MYTAB where FSC like '$FSC' and NIIN like 
'$NIIN';";
$result = mysqli_query($conn ,$mysql_qry);

if(mysqli_num_rows($result) > 0) {
$row = mysqli_fetch_assoc($result);
$PART_NUMBER = $row["PART_NUMBER"];
$FSC = $row["FSC"];
$NIIN = $row["NIIN"];
$ITEM_NAME = $row["ITEM_NAME"];

echo $ITEM_NAME, ", " .$PART_NUMBER, ", " .$FSC, ", " .$NIIN;
} else {
echo "Query Failed! - No such NSN is loaded to the database! Please double 
check the information is correct and resubmit request...";
}

mysqli_close($con);

?>

Let me start with this.. I've never programmed using .php script, and still relatively new to programming, I am working on a new project that centers around Android Studio IDE and I usually write in JAVA. I have been trying to use this .php script below that I've been modifying with what I need. It works well however, I am having trouble figuring out how to do a multi query, basically I am looking to have what my 'echo' line is but if there are more then one match to the FSC/NIIN field then it should show me the additional matches. 
 
Back history, there are more than one part number listed for some FSC/NIIN fields, I am working towards having it show those additional part numbers that match the stock number (FSC/NIIN). Any help or advice is greatly appreciated!
 
<?php 
require "conn.php";
$FSC = $_POST["FSC"];
$NIIN = $_POST["NIIN"];
$mysql_qry = "select * from MYTAB where FSC like '$FSC' and NIIN like 
'$NIIN';";
$result = mysqli_query($conn ,$mysql_qry);

if(mysqli_num_rows($result) > 0) {
$row = mysqli_fetch_assoc($result);
$PART_NUMBER = $row["PART_NUMBER"];
$FSC = $row["FSC"];
$NIIN = $row["NIIN"];
$ITEM_NAME = $row["ITEM_NAME"];

echo $ITEM_NAME, ", " .$PART_NUMBER, ", " .$FSC, ", " .$NIIN;
} else {
echo "Query Failed! - No such NSN is loaded to the database! Please double 
check the information is correct and resubmit request...";
}

mysqli_close($con);

?>

原文：https://stackoverflow.com/questions/48408525