Hello
I'm a real beginner so please excuse my lack of tech speak
I have a script that updates (add to) a mysql table. This is an example of it:
<html>
<body link="#4E5584" vlink="#4E5584" alink="#4E5584">
<?php
mysql_connect ("mysql.night-owl.co.uk", "db", "pw");
mysql_select_db ("db");
mysql_query ("INSERT INTO lyrics (artists, title, words) VALUES ('$artists', '$title', '$words')");
print ("<br><br><font face=Arial color=#4E5584>thank you<br><br>");
print ("<font face=Arial color=#4E5584>your lyrics have been added for <b>$title</b> to the lyrics database<br><br>");
print ("<font face=Arial color=#4E5584><a href=\"lyricsview.php\">view your entry</a></font><br><font face=Arial size=1 color=#4E5584>(it will be in alphabetical order)");
?>
</body>
</html>
Imformation is passed to this script from a standard HTML form web page ... it works fine except for one small problem. When the table is updated I would also like to replace any returns with <br> so that it retains a similar layout when entered into the text box ... if some can tell me what to add to the script above to achieve that it will be appreciated
TIA ... Mick
