PHP: Merge two MySql array result

Question

i fetch id and name from categories table like this :

  |id|name| tag |desc|order|status|
  |1 |test| NULL|NULL|  1  |   1  |


  $i = 0;
  $allcats = Access::FETCH("SELECT * FROM " . CATS . "");
     $cats = array();
  foreach($allcats AS $row2){                                               
     $cats[$i] = array("name" => $row2['name'], "id" => $row2['id']);
  $i++;                                             
  }

i fetch category id for each news :

|id|catid|storyid|
|1 |  1  |   5   |

$groupcats = Access::FETCH("SELECT * FROM " . GROUPCATS . " WHERE  storyid = ?", $row['postid']);

Now, i need to print name of cat for storyid. i,e : i need to print test(catname) for story id 5.

How do can i print this?

That's great. What have you tried?

tadman
– tadman

2014-06-08 19:38:05 +00:00
Commented Jun 8, 2014 at 19:38 — tadman
– tadman, Commented Jun 8, 2014 at 19:38
You need to research SQL JOINs.

Devon Bessemer
– Devon Bessemer

2014-06-08 19:39:59 +00:00
Commented Jun 8, 2014 at 19:39 — Devon Bessemer
– Devon Bessemer, Commented Jun 8, 2014 at 19:39
@tadman: i dont have any idea!!

user27133
– user27133

2014-06-08 19:42:31 +00:00
Commented Jun 8, 2014 at 19:42 — user27133
– user27133, Commented Jun 8, 2014 at 19:42

aland · Accepted Answer · 2014-06-08 19:45:32Z

3

Easier to do with with a join rather than in php. Something like,

$joinedcats = Access::FETCH("SELECT name FROM " . CATS . 
                            " JOIN " . GROUPCATS . " ON catid = id");
foreach($joinedcats as $row) {
     echo $row['name'];
}

See https://dev.mysql.com/doc/refman/5.5/en/join.html

answered Jun 8, 2014 at 19:45

aland

2,0742 gold badges29 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sh1d0w · Accepted Answer · 2014-06-08 19:46:48Z

0

You can use join to get needed rows for each story:

"SELECT * FROM " . GROUPCATS . " LEFT JOIN " . CATS . " USING(categoryid) WHERE  storyid = ?"

answered Jun 8, 2014 at 19:46

Sh1d0w

9,5203 gold badges26 silver badges35 bronze badges

Collectives™ on Stack Overflow

PHP: Merge two MySql array result

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related