How to display data queried by mysql $ SQL = & quot; SELECTc. cat_name, a. titleFROMhc_articleasaLEFTJOINhc_article_catAScONa.cat_id = c. cat_id & q the data display method queried by mysql
$ SQL = "SELECT c. cat_name, a. title FROM hc_article as a LEFT JOIN hc_article_cat AS c ON a. cat_id = c. cat_id ";
Use the preceding statement to query
Array
(
[0] => Array
(
[Cat_name] => Beginner's Guide
[Title] => user registration
)
[1] => Array
(
[Cat_name] => Beginner's Guide
[Title] => shopping guide
)
)
How can I arrange them
Array
(
[0] => Array
(
[Cat_name] => Array ([0] => Beginner's Guide)
[Title] => Array ([0] => user registration [1] => Shopping Guide)
)
)
------ Solution --------------------
PHP code
$ Ar = Array ('0' => Array ('cat _ name' => 'beginner's Guide', 'title' => 'User registration '), '1' => Array ('cat _ name' => 'newbie's guide ', 'title' => 'shopping Guide'); foreach ($ ar as $ v) {if (! $ T [$ v ['cat _ name']) {$ t [$ v ['cat _ name'] ['cat _ name'] = array ($ v ['cat _ name']); $ t [$ v ['cat _ name'] ['title'] = array ($ v ['title']);} else $ t [$ v ['cat _ name'] ['title'] [] = $ v ['title'];} print_r (array_values ($ t ));
