I am having some problems fetching the array from my database properly. All my text is being echoed in lowercase. While the text in the database is both lower & uppercase. How can make it fetch properly? This is my actual SQL request:
$page = (int) (!isset($_GET['p'])) ? 1 : $_GET['p'];
$sql = "SELECT * FROM newsfeed_status AS ns LEFT OUTER JOIN login AS lo ON ns.user = lo.id WHERE ns.status_deleted is null ORDER BY ns.status_id DESC";
$start = ($page * $limit) - $limit;
if( mysql_num_rows(mysql_query($sql)) > ($page * $limit) ){
$next = ++$page;
}
$query = mysql_query( $sql . " LIMIT {$start}, {$limit}");
?>
I use this to start a while
statement:
<?php while ($row = mysql_fetch_array($query)): ?>
and here I echo the status text using this:
<?php echo $row['post']?>
My input looks like this:
share my thoughts? i'll give you thoughts!
When I want this:
Share my thoughts? I'll give you thoughts!
This is my var_dump($row['post']); result:
share my thoughts? i'll give you thoughts!string(42) "share my thoughts? i'll give you thoughts!"