Try this:

if( $row["label"] = "address"){ echo "<br>"; }

Hello Axel,

I am not getting the page not working after using your advice. However I am not getting the line break.

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);

// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}

$sql = "SELECT order_id, label, value FROM cartinvoice_addresses";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo " " . $row["label"]. " " . $row["value"] ;
if( $row["label"] = "address"){ echo "<br>"; }

}
} else {
echo "0 results";
}
$conn->close();
?>

Try to modify your script with :

$conn = mysqli_connect("my_server", "user", "password", "dbname");

and to save it in PHP file like test.php

and try tu use your test.php  without WSX5. Directly from your web server like https://myserver.com/test.php

It's better to debug the PHP script outside of WSX5.

When it's run, you can add it to use it...

Hope this helps

Axel

Thanks, I'll give it a go.

Hello Errol,

The comparison operator for equality in PHP is a double equals sign as opposed to a single.

Thus:

if( $row["label"] == "address")

This is why your code is failing the if statement.

Also, you might want to capitalise "address" to match what is in the MySQL database.

if( $row["label"] == "Address")

Kind regards,

Paul

Search the WebSite X5 Help Center

Paul, that did the trick.

Great, thanks for letting us know!