definitely need help with this problem

[divinedesigns1]

hey, i need some help, i am trying to use an array to create an dynamic statement so i can create this page no matter what the own decided to add to the database

$query = mysqli_query($con, "SELECT * FROM department ORDER BY id ASC") or die('Error: ' . mysqli_error($con));
        if($query){
            while($row = mysqli_fetch_assoc($query)){
                $id = $row['id'];
                $name = $row['name'];
                $list[] = $name;
                $detail = $row['description'];
                $department = $row['type'];
            }
        }
        foreach($list as $items){
            $items = strtolower($items);
            echo $items . '<br>';
        }
        if($product == $items){
        }

ok so the above codes, get all the information for me, which i need, it then add the name only to the array list[]. after that i used the foreach function to convert the array, and remove all uppercases to lowercases.

 

now for the last statement it suppose to create an if statement which it compares the items, to the $product and if it does then it does something. but this is the part i need help with.

 

how do i go about getting this done? any tips or hints?

[Don E]

Is $product suppose to be string containing a product name? You can have the if statement inside the foreach loop. When it loops through and $product is equal to $items, then do something.

[divinedesigns1]

Is $product suppose to be string containing a product name? You can have the if statement inside the foreach loop. When it loops through and $product is equal to $items, then do something.

yes the $product gets the name from another page. and ill definitely try that, thanks Don