CODEWITHSUNDEEP
phpmysql
Xeen
Xeen

Reputation: 7003

How to loop data from multiple tables in MySQL?

I have these tables with the following columns:

Article

1.1. title
1.2. text
1.3. sortnr

Congress

2.1. title
2.2. text
2.3. sortnr

And, obviously, others, but these are the ones that are the same. And what I'd like to do is write a query where I can then loop through these fields as if they were from one table.

What it looks like:

SELECT * FROM article, congress ORDER BY sortDate DESC LIMIT 3

but with that I can't use fields like title and so on because during the loop, all the, for example, title fields are being turned in to the ones from congress table.

Is there a way to mix the two tables and treat them like they were from one table considering that they aren't joined in any way?

Upvotes: 1

Views: 99

Answers (1)

Ahmed Ginani
Ahmed Ginani

Reputation: 6650

Try this:

SELECT *, 'article' as tblnm FROM article
UNION
SELECT *, 'konferansenentry' as tblnm FROM konferansenentry 
ORDER BY sortDate DESC 
LIMIT 3

It will only work if both table have same field other wise you have to select individual one by one.

Upvotes: 2

Related Questions