如何回显单个行字段[重复]

Question

This question already has an answer here:

• How get all values in a column using PHP? 6 answers

Im wondering how do I echo a SINGLE rows fields, for example:

|username|

user1

user2

user3

user4

user5

how would I echo ALL fields in a row onto a php or html page? "I tried" to google it but I couldnt find this, I could only find echoing all ROWS. please help.

</div>

Answer 1

if you have a mysql database then use:

$SQL = "SELECT <Rowname> FROM <Tablename>";
$query = mysqli_query(<db-connection>,$SQL);
while($row = mysqli_fetch_object($query)){
echo $row-><Rowname>;
}