I wanted to search 2 tables (news and photos) and then display the results of this query below. But the fields I have in each table are different and I'm not able to work out a way to display the results because of that.
News table fields: Title, photo, description, content, date
Photo table fields: Title, photo, date, location
Ex:
Note: The image layout is just an example, what I can not do is the code that generates the result. If it were the result of a table only displaying results only from it I can do but displaying results from 2 tables together and merged I could not.