php foreach loop on mysql data from 2 tables?

Question

I have two tables, both with only one column.

Table 1:  Merchants
Column:  merchant  (20 entries)

Table 2:  Categories
Column: category  (600 entries)

I'm trying to write a for each loop to select all entries within these two tables and list all possible combinations in this format. For example..

merchant1 category1
merchant1 category2
merchant1 category3... all the way to end of categories
merchant2 category1
merchant2 category2
merchant2 category3...all the way to end of categories
etc...

Should I use one mysql command to select the data, then use a for each loop?... or should I run 2 mysql commands and use a nested for each loop on multiple arrays?

Sorry this isn't super constructive but I'd say "6 of one and half a dozen of the other". — Wee Zel
– Wee Zel, Commented Jul 25, 2015 at 5:36

Don Bartolome · Accepted Answer · 2015-07-25 05:33:01Z

3

SELECT `Merchants`.`merchant`, `Categories`.`category`
FROM `Merchants`
JOIN `Categories`;

Then do a foreach on the result.

answered Jul 25, 2015 at 5:33

Don Bartolome

614 bronze badges

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

Comments

Caleb Kleveter · Accepted Answer · 2017-04-14 15:13:09Z

2

SELECT table1.(put the star sign), table2.(put the star sign)
FROM table1
INNER JOIN table2 ON 1=1

edited Apr 14, 2017 at 15:13

Caleb Kleveter

11.6k8 gold badges68 silver badges94 bronze badges

answered Apr 14, 2017 at 14:50

Ahmed_Schrute

1662 silver badges4 bronze badges

Comments

JOE LEE · Accepted Answer · 2015-07-25 05:33:01Z

1

use outer join,

SELECT * FROM Merchants, Categories    //Number of Records:20 X 600

answered Jul 25, 2015 at 5:33

JOE LEE

1,0581 gold badge6 silver badges6 bronze badges

Collectives™ on Stack Overflow

php foreach loop on mysql data from 2 tables?

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