Pass a database recordset to a string variable in php

Issues with the code below: current issue is I am trying to get the entire database recordset into the $message variable, it's placement currently means it's not looping through records and I can't think how to do it. So, I need the entire recordset, all fields and rows passed to the $message variable. <?php $servername = "localhost"; $username = "root"; $password = "yeahyeah"; $dbname = "transport"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "SELECT * FROM tmpdiscounts"; $result = $conn->query($sql); function send_line_notify($message, $token) { $ch = curl_init(); curl_setopt( $ch, CURLOPT_URL, "[login to view URL]"); curl_setopt( $ch, CURLOPT_SSL_VERIFYHOST, 0); curl_setopt( $ch, CURLOPT_SSL_VERIFYPEER, 0); curl_setopt( $ch, CURLOPT_POST, 1); curl_setopt( $ch, CURLOPT_POSTFIELDS, "message=$message"); curl_setopt( $ch, CURLOPT_FOLLOWLOCATION, 1); $headers = array( "Content-type: application/x-www-form-urlencoded", "Authorization: Bearer $token", ); curl_setopt($ch, CURLOPT_HTTPHEADER, $headers); curl_setopt( $ch, CURLOPT_RETURNTRANSFER, 1); $result = curl_exec( $ch ); curl_close( $ch ); return $result; } if ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_assoc()) { $msg = "id: " . $row["idtmpdiscounts"]. ", "; } } else { echo "0 results"; } $message = $msg; $token = 'FRkMjKH2zqFv4j8Ge1hRNg4Hb8j3sRIAUFV8QZVBfEl'; echo send_line_notify($message, $token); $conn->close(); ?>