KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have three tables in my database which are: messages topics comments Each of these tables has two fields called 'content' and 'title'. I want to be able to use 'Like' in my sql statement to look at 'messages.content', 'messages.title', 'topics.content', 'topics.title', 'comments.content' and 'comments.title' using a keyword. So far, my query is able to find results from only one table: mysql_query("SELECT * FROM messages WHERE content LIKE '%" . $keyword . "%' OR title LIKE '%" . $keyword ."%'"); I am also wondering, once I get the results from multiple tables, how can I tell what result is from what table? Any help would be greatly appreciated!
Tags (comma-separated)
Save Edits
Cancel