title: MYSQL Display result in single row
body: <p><img src="https://i.stack.imgur.com/puREw.png" alt="message table"></p>
  
  <p><img src="https://i.stack.imgur.com/1Yawh.png" alt="response table"></p>
  
  <p>Sorry, my account is new so it's not allowing me to upload more than two images, so <a href="https://i.stack.imgur.com/kj70V.png" rel="nofollow noreferrer">this is the third image</a>.</p>
  
  <p>MySQL query:</p>
  
  <pre><code>SELECT  *,
          `message`.`status` as `message_status`,
          `message`.`id` as `message_id`
  FROM    `message`
  LEFT JOIN
          `pet_info`
  ON      `pet_info`.`id` = `message`.`pet_id`
  LEFT JOIN
          `response`
  ON      `response`.`message_id` = `message`.`id`
  WHERE   `user_id` = '1' AND
          `pet_id` = '6'
  </code></pre>
  
  <p>This query displaying me more than 2 rows. I want to display the result in a single row How can I do this please help me.</p>