I'm retrieving some data from my database and displaying in my page. But when I get them,
Some text from the text is missing. For example, if I have a text in my database saying
"HELLO HELLO MY NAME IS ARAGORN,
IM POSTING IN A FORUM"
It might display as,
"HELLO HELLO M
IM POSTING IN A FORUM"
Here's my code..
- Code: Select all
<?php
if(isset($_POST['search'])){
$Language = $_POST['Language'];
$criteria = $_POST['criteria'];
$query = "SELECT * FROM songs WHERE Title LIKE '$criteria%' AND Language = '$Language' ";
$result = mysql_query($query) or die ("ERROR");
while($row = mysql_fetch_array($result)){
echo "<br/><br/>";
echo "<b><h1>";
echo $row['Title'];
echo "</b></h1>";
echo "<br/><br/>";
if($Language == 'Sinhala'){
echo "<span class=sinhala>";
}
echo nl2br ($row ['Lyrics']);
echo "</span>";
echo "<br/><br/>";
echo "<br/><br/>";
}
echo "<br/><br/>";
}
?>
The Lyrics cell is of type TEXT...
