using join and push result in the array

Question

I have two tables , Names and Pics

Names table :

enter image description here

Pics table :

enter image description here

I would like to write a function in the php(by using sql) that it gets an id and return a result like this :

//suppose I sent 1 to this function...

result = array("name"=>"Name1","pics"=>"url6-url7");

There are hyphen in the URLS.

any helps?

I just know : $sql = "select * from Names,Pics where Names.ID = Pics.Name_ID"; — S.M_Emamian
– S.M_Emamian, Commented Sep 19, 2014 at 10:25
select * from Names,Pics where Names.ID = Pics.Name_ID AND Names.ID=$inputId — Sadikhasan
– Sadikhasan, Commented Sep 19, 2014 at 10:33

vinod · Accepted Answer · 2014-09-19 11:17:54Z

2

`Try this code its working 

SELECT GROUP_CONCAT(category.pics SEPARATOR '-') as newpics, company.id as searchid FROM `category` inner join  company on (company.id = category.cmp_id) where category.cmp_id = 2

answered Sep 19, 2014 at 11:17

vinod

2,8901 gold badge20 silver badges23 bronze badges

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

Comments

Shaunak Shukla · Accepted Answer · 2014-09-19 11:06:29Z

1

function whatIsThis($id){
   global $db;
   $sql = "select name, pics from names,pics where names.ID = pics.Name_ID AND names.ID = ".$id;
   $res = $db->query($sql);
   // Logic starts here...
   foreach($res as $rk=>$rv){ 
      $result['name'] = $rv['name'];
      $r[] = $rv['pics'];
   }
   $result['pics'] = implode('-',$r);
   return $result;
}
$iWant = whatIsThis('1');

I've used my own database class for query, you can use your own..
$iWant will return array as you need!

answered Sep 19, 2014 at 11:06

Shaunak Shukla

2,3472 gold badges19 silver badges30 bronze badges

Comments

user1930857 · Accepted Answer · 2014-09-19 10:34:07Z

0

Considering your sql result in $sql, use var_dump to print the result and you will get the output result in the form of array that you want :)

answered Sep 19, 2014 at 10:34

user1930857

Collectives™ on Stack Overflow

using join and push result in the array

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related