can PHP load the value of a column in MySQL into an single-dimension array?
For example, table name
Field
|
————————————
| | |
ID class Grade
1 a T
2 b W
3 C Z
As above, for example, the field class this column, loaded into a single-dimensional array!
The default mysql_fetch_array is to load the rows into an array, and now I want to load a column into an array
------Solution--------------------
MySQL returns a two-dimensional array that you can encapsulate again.
------Solution--------------------
The MySQL function group does not provide this functionality and requires programmatic resolution
PDO provides this functionality
------Solution--------------------
You read the value of the dequeue and put it in a single-dimensional array inside the program for other places.
------Solution--------------------
When you query, only one field will be a short time.
PHP Code
$sql = "Select class from Name", $result = mysql_query ($sql, $this->mysql) and while ($arr = Mysql_fetch_array ($result)) { C1/>print_r ($arr);} Mysql_close ();