So I’m trying to make this search engine for my blog…
And I need to get stuff from 2 tables: “entries” and “comments”. Each of these tables has a “date” field indicating when the entry/comment was submitted
I need to mix them and order by date…
And I need to do this using one query… I tried 2 separate ones and them ordering them somehow and checking each one’s date and stuff but then my page-system wouldn’t work. (displaying them on separate pages)
so basically… I need to get data from 2 mysql tables, mix them up and order them by date… how would I do that?
