How can you output multiple columns from a MySQL database into a single row in PHP?

To output multiple columns from a MySQL database into a single row in PHP, you can fetch the data using a query and then concatenate the values into a single string. You can achieve this by using the CONCAT function in your SQL query to combine the values from different columns into one. Then, fetch the result and display it as needed in your PHP code. 

<?php
// Connect to MySQL database
$connection = mysqli_connect("localhost", "username", "password", "database");

// Query to fetch multiple columns into a single row
$query = "SELECT CONCAT(column1, ', ', column2, ', ', column3) AS combined_columns FROM table_name WHERE condition";

$result = mysqli_query($connection, $query);

// Fetch and display the result
while($row = mysqli_fetch_assoc($result)) {
    echo $row['combined_columns'];
}

// Close database connection
mysqli_close($connection);
?>

Keywords

PHP MySQL database multiple columns single row

Related Questions