Dealing with \n\r

Hi All,

I have another problem ... just as things were going well :^(

I have a web site that allows a free text input which gets sanitised and subsequently added to a MySQL database. The sanitisation process is by :

$problem_description = mysqli_real_escape_string($conn, $_POST['problem_description']);

It is then inserted into the database with:

$insert_data = $conn->prepare("INSERT INTO raw_data (Contact_Name,  Problem_Description) VALUES (?, ?)");
 $insert_data->bind_param("ss", $contact, $description);
 
 $contact = $contact_name;
 $description = $problem_description;

When it is retrieved if the user has entered line breaks by pressing the enter key it gives:

text block 1\n\rtext block 2

instead of

text block 1
text block 2


The retrieval process is:

<?php
$data = "SELECT * FROM raw_data WHERE id='$ticket_number'";
$result = mysqli_query($conn, $data);
$value = mysqli_fetch_array($result);
?>

<textarea id='edit_problem_description' name='problem_description' required readonly="readonly"><?php echo $value['Problem_Description']?></textarea>

How do I make the text show as required please?

I have scoured the internet and nothing I try seems to help. With this in mind I have doubled the usual reward - I have 2 virtual nights out on the town to offer, but they cant be taken until the world is free of this nasty COVID-19 virus.