mysql - How to get all values in a certain column with php -

i need print out usernames of members in site list, don't know how it. tried use 'mysqli_fetch_array' function fetch names username column, i've been failing. so, please assist me on how can in efficient way.

this code

$sql = "select username users"; $query = mysqli_query($db_con, $sql); $array = array; while($row = mysqli_fetch_array($query)) {       $array =  row[]; } foreach ($names $array) {      echo $names; } 

also want format output, separating each username " | "

you quite close..

$sql = "select username users"; $query = mysqli_query($db_con, $sql);  while($row = mysqli_fetch_assoc($query)) {     echo $row['username'].'|'; }