Traversing data in a database table in PHP

Data in the database:

1. Iterate through each column of each row, respectively

The Mysql_fetch_row () function automatically moves the pointer backward one unit after each traversal

while ($row =mysql_fetch_row ($result)) {
echo "Date:". $row [0]. "     <br/> "; Row[i] The first few fields of the row (that is, the first few columns)
echo "Name:". $row [1]. " <br/> ";
}

The output is:

Date: 2015-11-25 14:24:42
Name: Zhangliang
Date: 2015-11-25 14:36:36
Name: AB
Date: 2015-11-25 14:36:36
Name: ABS

Read the entire row of data at once

while ($row =mysql_fetch_row ($result)) {//while () is the function of moving the pointer backwards, giving the next row of data to $row
foreach ($row as $value) {
echo $value. " <br/> ";
}
}

The output is:

2015-11-25 14:24:42
Zhangliang
2015-11-25 14:36:36
Ab
2015-11-25 14:36:36
Abs

Traversing data in a database table in PHP