如何在php数据库中循环一部分列

Question

I want to select only a part of "catergorie" with the value "Shirts".

is there a way to loop though that so i can echo it?

Answer 1

Use this query:

$query = SELECT * FROM `tabel_naam` WHERE `categorie` = 'Shirts'

Als je deze query uit de database haalt, dan kun je er doorheen loopen met: When you use this query, you can do this to loop through it:

$con= mysqli_connect("localhost","my_user","my_password","my_db");

$result=mysqli_query($con,$query);

while($row= mysqli_fetch_all($result,MYSQLI_ASSOC)) {
    echo $row['columnname'];
}

mysqli_free_result($result);

mysqli_close($con);