WmZilla - Webmaster and Marketplace

The Next Generation Webmaster and Trade Forum

How should I write an SQL query for this type of output?

Mannuel

New member

0

0%

Status

Offline

Posts

33

Likes

0

Rep

0

Bits

175

3

Months of Service

0%
Hello friends; I have two tables, one being the duel table and the other the team table. In the duel table, I am writing the IDs of the data in the team table in the first_team and second_team columns. However, since there are two team IDs in a single row, I am unable to get the desired output. What kind of query should I write or PHP loop should I create? Duel table: team table: Desired output:
 

249

6,622

6,642

Top