1
I wanted to do a search in 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 elaborate a way to display the results because of this.
Fields from the news table: Title, photo, description, content, date
Fields of table photos: Title, photo, date, location
Ex:
- Search the term "test"...
- Query in the two tables and brings all the results found.
The search result wanted to look like the image:
Note: The layout of the image is just an example, what I am not able to do is the code that generates the result. If it was the result of a table only displaying results only of it I can do, but displaying results of 2 tables together and merged I could not.
What you have code so far?
– Gabriel Heming
Actually nothing. But I will post as use to display results of a table.
– Frederico Moreira
From a read in https://answall.com/questions/208941/como-fazer-inner-join-em-mysql
– Gabriel Heming