Search code examples
mysqlinner-join

PHP MySQL select all matching rows and echo another table's rows

I have 2 table message and answer. where message id = answer id. I want select using message. when message = hi then expected answer hello, hey.

Message Table:
|  id  |  message |
|   1  |    hi    |
|   2  |    hi    |
|   3  |    Hi    |

and answer table:

| id | answer |
| 1  | hello  |
| 2  | hey    |
| 3  | Hello  |

I already tried: $inp = "hi";

SELECT * FROM message JOIN answer ON message.message = answer.answer WHERE message='$inp'"
Solution

  • Try this code :

    "SELECT * FROM message JOIN answer ON message.id= answer.id WHERE message.message='".$inp."'";