I am building a social networking site that is dedicated to nightclubs and night events.
Among other tables, I have a users table, events table and establishments table.
I am really intrigued with how Facebook in particular is able to query and return matches of not just users but also pages, ads etc row after row. Im sure most who are reading this have tried the facebook search
My question is in my case, should I:
1. Perform 3 separate LIKE %search% on each of the tables on search.php.
2. Draw up 3 separate tables to show the results of what matches in the relevant queries which are collapsed when empty(on the same search.php) ie
table to show matched users
user_thumb name addfriend
table to show matched events(table does not show if no event match result)
event thumb, event name etc.
I need help.