Categories, whilst only displaying the category title once. I have one table that holds the category title (the parent) and the second table which holds the sub-category information. Although when displaying the information, I dont know how to show the category information only once.
x
$result_array = mysqli_query($connect, "SELECT *
FROM tbl_customer, categories
WHERE tbl_customer.category_QA = categories.id
ORDER BY Category ASC");
while ($data = mysqli_fetch_array($result_array)) {
echo $data["Category"]; //display once for every new category
echo $data["productName"];
}
Advertisement
Answer
You could check for change
$result_array = mysqli_query($connect,"SELECT * FROM tbl_customer, categories WHERE tbl_customer.category_QA = categories.id ORDER BY Category ASC");
$checkCategory = '';
while($data = mysqli_fetch_array($result_array)){
if ($checkCategory != $data["Category"]){
echo $data["Category"]; //display once for every new category
$checkCategory = $data["Category"];
}
echo $data["productName"];
}