Value1 Value2 Value3 Value4 "; if ($result = $mysqli->query($query)) { while ($row = $result->fetch_assoc()) { $field1name = $row["productname"]; $field2name = $row["asin"]; $field3name = $row["salesprice"]; $field4name = $row["quantity"]; echo ' '.$field1name.' '.$field2name.' '.$field3name.' '.$field4name.' '; } $result->free(); } ?>