php数据库里中文类型,当将鼠标悬停在php和mysql中的类别名称上时，显示数据库中每个类别的子类别...

您正在使用外部查询的所有结果集，而未在内部循环中使用它。

下一个问题也是对两个查询使用相同的变量，因为当您运行内部查询时，它将破坏外部外观的结果集

$sql=mysqli_query($con,"SELECT id,categoryName FROM category");

while($row=mysqli_fetch_array($sql)) {

?>

//} this causes the first loop to run to its end hence only one category processed

?>

// use different variable otherwise you will destroy the first resultset

$sql1=mysqli_query($con,"SELECT id, subcategory

FROM subcategory

WHERE categoryid= '$row[id]'");

while($row1=mysqli_fetch_array($sql1)){

?>

} // end inner while

} // end outer while

?>

I do have to mention that you are open to SQL Injection Attack.

Even if you are escaping inputs, its not safe!

You should consider using prepared parameterized statements in either the MYSQLI_ or PDO API's instead of concatenated values